Home Dashboard Directory Help

CREATE OR ALTER statement by Rafs



Sign in
to vote
Type: Suggestion
ID: 344991
Opened: 5/19/2008 10:01:25 PM
Access Restriction: Public
Duplicates: 351217
Primary Feedback Item: 127219


It's desirable for SQL Server 2008 to have a kind of CREATE OR ALTER statement in T-SQL for objects creation.

While it seems to be unimportant feature, it's a desirable feature that safe some typing and simplify scripting. I've suggested that feature for SQL Server 2005, and it was dropped on the Beta. Said it would ship in a future version. I don't see the feature in any CTP of SQL Server 2008. I don't how can it be so dificult to implement it, since T-SQL has received so many improvements since SQL 2000, why not a so simple one like this?
Sign in to post a comment.
Posted by ArthurZ on 3/27/2014 at 6:57 AM
This is a much awaited "syntactic sugar" productivity boost that exists in other RDBMS implementations for a long time.
This addition also appears to be a non-breaking change.
Besides, both links to duplicate posts above don't resolve due to: "The system has encountered an unexpected error."
Posted by Microsoft on 3/24/2010 at 2:15 PM
I have resolved this request as duplicate of feedback item below:


Umachandar, SQL Programmability Team
Posted by AaronBertrand on 5/25/2008 at 7:53 AM
This is a duplicate request. Better to add voting weight to the following item, instead of spreading it out:

Posted by Microsoft on 5/20/2008 at 3:18 PM
Thanks for the valuable suggestion.

Given the release schedule, we're not able to make it as part of SQL Server 2008.

On the other hand, it's being considered as a top feature in our TSQL enhancement list for the next major release.

Sign in to post a workaround.