Skip to content

delete-without-where-clause (GN023)#

Automatic fix is not available.

What it does#

Checks for DELETE without a WHERE clause.

Why not?#

Executing a DELETE line without a WHERE clause will remove all the rows in the table which is most likely an accidental mistake and not what you want.

When should you?#

Never.

Use instead:#

Add necessary WHERE clause.