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.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 can we change primary key

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.
Go to Top of Page
   

- Advertisement -