Create or Replace xxx - by Ricky Datta

Status : 


Sign in
to vote
ID 351217 Comments
Status Active Workarounds
Type Suggestion Repros 0
Opened 6/15/2008 9:20:57 PM
Access Restriction Public
Primary Feedback Item 344991


Can we support a syntax "create or replace object" rather than "if lookup(catalog) delete objct; create object" like oracle for SQL Server objects in DDL?
Sign in to post a comment.
Posted by Microsoft on 1/15/2016 at 4:31 PM
Closing this as duplicate and tracking at
Posted by Microsoft on 6/17/2008 at 10:13 AM
Thankyou for this request.

However, there's another request for the same feature, already "in-the-system". So I am closing this one as a duplicate of that earlier request - VSTF#225701, PS#635700, FEEDBACK#127219 (yep, just one bug, but 3 tracking databases!)

This feature is near the top of our todo list for the upcoming release. It is one of the most-voted-for features.


Posted by AaronBertrand on 6/16/2008 at 8:53 AM
This is a duplicate of ... please cast votes there instead of spreading them out.