ALTER TABLE ALTER CONSTRAINT - by br33

Status : 

  Won't Fix<br /><br />
		Due to several factors the product team decided to focus its efforts on other items.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


3
0
Sign in
to vote
ID 520020 Comments
Status Closed Workarounds
Type Suggestion Repros 0
Opened 12/13/2009 1:43:22 AM
Access Restriction Public

Description

Ability to change the columns of a PK or UK without having to DROP and ADD the CONSTRAINT.
Like a CREATE INDEX CLUSTERED... WITH DROP_EXISTING.
On big tables (hundreds of GB) would save lot of time.
Sign in to post a comment.
Posted by Microsoft on 5/17/2011 at 12:24 PM
After consideration implementaion impact and any time savings on the application, we decided not to support this request. Thanks for your suggestion.

Best regards
Microsoft SQL Server Engine Team
Posted by Boris [MSFT] on 12/28/2009 at 6:14 PM
Hello,

Thank you for submitting the feedback! We will consider the ability to add/alter constraints in a single statement (as you suggested in the feedback) in future releases of SQL Server.

Thank you and regards,
Boris Baryshnikov.
SQL Server Engine