Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
MattC
Starting Member
9 Posts |
 Posted - 2012-12-19 : 10:29:47
|
| Ok, so I've got a newbie question ...I am using the Object Explorer in SQL Server Management Studio. I am interested in what the keys are for a certain table. When I go to the table and display the keys I see two different colored icons. One is a yellow key icon that identifies the primary key for the table . The second is a grey colored key. Can someone tell me what this grey key is identifying? Many Thanks, |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-12-19 : 10:33:14
|
| grey key icon stands for foreign key relationship. those are columns which are related via foreign key relationship to another tables primary key. Right click on any one of them and choose script as option and you'll get create script for foreign key.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
MattC
Starting Member
9 Posts |
Posted - 2012-12-19 : 10:47:19
|
| Of course - thank you. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-12-19 : 11:13:24
|
| welcome------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Server Management Studio - Meaning of Icon