Home Dashboard Directory Help
Search

ALTER TABLE ALTER CONSTRAINT by br33


Status: 

Closed
 as Won't Fix Help for as Won't Fix


3
0
Sign in
to vote
Type: Suggestion
ID: 520020
Opened: 12/13/2009 1:43:22 AM
Access Restriction: Public
0
Workaround(s)
view

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.
Details
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 Microsoft 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
Sign in to post a workaround.