Question

Locked

primary key

By dbyakes ·
can we change primary key in sql server? if can how?

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Collapse -

yes

by Shellbot In reply to primary key

how do you want to change it?
do you want to delete your existing one?

if so:

ALTER TABLE tablename
DROP CONSTRAINT primarykeyname

make sure you've nothing dependant on this before you do it though..

or are looking to modify it?

have a read of BooksOnline..search CONSTRAINT
or even have a look at this:
http://msdn.microsoft.com/en-us/library/aa275462(SQL.80).aspx

Back to Networks Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums