Changing a Primary Key on a table in Design View - by vs2015junkie

Status : 

  By Design<br /><br />
		The product team believes this item works according to its intended design.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.

Sign in
to vote
ID 323951 Comments
Status Closed Workarounds
Type Bug Repros 0
Opened 1/24/2008 7:47:50 AM
Access Restriction Public


When changing a Primary Key in Design view using SQL Server 2008 November CTP, you receive an error message that the changes cannot be saved.
Sign in to post a comment.
Posted by Microsoft on 1/24/2008 at 9:51 AM

Thank you for reporting the problem. The message shown is due to the default option in SSMS.

If your change requires a Table Drop / Recreate and you would like to proceed with this option, please enable the same by doing the following:

* Go to Tools-> Options
* Click on Designers
* Uncheck the 'Prevent saving changes that require table recreation'