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 |
|
rammohan
Posting Yak Master
212 Posts |
 Posted - 2006-10-04 : 05:14:52
|
| hi, here i am trying to create a table in which i want give a property autonumber(i.e increments simultaneously for each new row) to a field.pls tell me the procedure for this in sql server2005doubt2: i had created a table before with one primary key column. next i want to add a new column to the table and it also be a primary key.what is the procedure to add a primary key constraint column in a table if that table has already a primary key. i want multiple columns must contain primary key consatrints.thanx in advance,rammohan |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-10-04 : 05:23:00
|
| I think you need to add the new column, drop the old pk and add the composite pk.Peter LarssonHelsingborg, Sweden |
 |
|
|
|
|
|
problem at constarints