Warning on delete and update statements if no WHERE clause is specified
It would be nice to get a warning on delete or update statements if you did not specify a where clause.
SQL Prompt 7.2 displays execution warnings before executing DELETE or UPDATE statements without a WHERE clause. You can download the latest version from http://www.red-gate.com/products/sql-development/sql-prompt/
"If the deletion is on a table join, I don't want to be told that I have no where clause. The warning is erroneous."
same here, i keep getting this warning, but they definitely have where clauses. they are also deletes with table joins.
Todd B commented
If the deletion is on a table join, I don't want to be told that I have no where clause. The warning is erroneous.
Kevin Greiner commented
SSMS Boost just added this feature recently.