"drop user"
Highlight of today was when I ran
DROP USER MyUser
In the wrong (production) database.
Please add a warning to SQL Prompt, like your
"You're about to execute a DELETE statement without a WHERE clause"
When you run a DROP USER or a DROP LOGIN statement on a production server. Not only does the user or login disappear, but also all rights granted to the user.
Maybe add the question “are you in the correct database?”
3
votes
Henrik Staun Poulsen
shared this idea
-
Dan Obermiller
commented
I think it would be even nicer if there was just a way to configure what kinds of commands & statements you want a warning for, with nice defaults for delete/update w/o where, drop user/login, etc