Code Analysis

BP017

DELETE statement without WHERE or INNER JOIN clause

The DELETE statement has neither a WHERE nor an INNER JOIN clause, and it will delete the whole table when executed.

It is very easy to delete an entire table when you mean to delete just one or more rows. Delete statements should also be in a transaction so you can check the result before committing.

Available in

SQL Prompt

SQL Code Guard



Didn't find what you were looking for?