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?”
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