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.


1
0
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

Description

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
Hi,

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'

Thanks
Karthik