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 |
|
xrum
Yak Posting Veteran
87 Posts |
 Posted - 2009-05-22 : 13:15:25
|
| Hello,I am very new to the sql administration and am trying to add a composite primary key to a field but am unable to find a way to do it.what i've done so far was right click on the arrow (to the left of the column name) in the table designer, and went to indexes/keybut i don't know what to do now, please help Thanks! |
|
|
mualsh
Starting Member
8 Posts |
Posted - 2009-05-22 : 15:52:36
|
| Does this mean that you do not see 'set primary key' as an option on the same drop-down menu that you see the 'indexes/key' option? I have to admit its been over a year since I worked with enterprise manager. I know management studio 2005 offers the 'set primary key' option on that drop-down menu. If you would like I can always pass along a SQL script that you should be able execute from your query analyzer that would help you create your composite primary key. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-05-23 : 11:47:16
|
| http://social.msdn.microsoft.com/Forums/en-US/sqltools/thread/6f9a7df1-0721-4c49-84bf-c360f0df0b6d |
|
|
|
|
|
|
Creating composite Primary Key in Enterprise Manag