Home Dashboard Directory Help

SSMS : change "Delete" to "DROP" on context menu for objects by AaronBertrand


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

Sign in
to vote
Type: Suggestion
ID: 473286
Opened: 7/8/2009 10:37:14 AM
Access Restriction: Public


I see plenty of confusion about what DELETE dbo.Table; does compared to DROP TABLE dbo.Table; ... I think the context menu in Object Explorer perpetuates this confusion, since it says Delete instead of DROP. A lot of new users may assume that "deleting" a table from the context menu might be doing the same thing as DELETE dbo.Table; (though, admittedly, there will always be people who think DELETE does the same thing as DROP).
Sign in to post a comment.
Posted by Microsoft on 7/9/2009 at 9:48 AM
Hi Aaron,
Thank you for your suggestion regarding delete vs. drop. Changing this is likely to introduce more confusion to customers. I agree that a DBA will get it immediately, but developers using the tool could be just as confused seeing DROP. I'm closing this as by design.
Thank you,
Bill Ramos
Sign in to post a workaround.