CREATE OR ALTER statement by Rafs

Active

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

Workaround(s)

view

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?

Details (expand)

English

SQL Engine

Include the CREATE OR ALTER DDL statement in the Transact-SQL for the main object types, like Stored Procedures, User-Defined Functions, Triggers, Users, etc.

Faster Development

Improved Administration

Other (please provides details below)

Improved scripting of the schemas

0 attachments

Posted by Microsoft on 3/24/2010 at 2:15 PM

Hi,
I have resolved this request as duplicate of feedback item below:

https://connect.microsoft.com/SQLServer/feedback/details/127219/create-or-replace

--
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:

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=127219

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.

thanks

Microsoft