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 |
|
divyaram
Posting Yak Master
180 Posts |
Posted - 2009-06-01 : 05:55:49
|
| can we change primary if we to alter the table |
|
|
LoztInSpace
Aged Yak Warrior
940 Posts |
Posted - 2009-06-01 : 08:02:20
|
| You can but you should consider if it is the right thing. Permanent uniqueness is usually what makes it a primary key. Obvious exceptions are when you have tables that join 2 other tables, but you usually delete & re-insert these. |
 |
|
|
|
|
|