SSMS can't drop a Default Constraint - by Jean-Nicolas BERGER

Status : 

  Fixed<br /><br />
		This item has been fixed in the current or upcoming version of this product.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


5
0
Sign in
to vote
ID 491938 Comments
Status Closed Workarounds
Type Bug Repros 6
Opened 9/24/2009 1:33:47 PM
Access Restriction Public

Description

SSMS can't drop a Default Constraint. It says that de constraint does not exist.
The only way to drop the constraint seems to be to script the ALTER TABLE ... DROP CONSTRAINT ...
Sign in to post a comment.
Posted by Steve Kass on 9/27/2009 at 10:51 AM
This is similar to https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=315511.