DELETE FROM dbtab
without a WHERE
condition deletes all the entries of the table. Check whether dataset to be deleted can
be limited by a suitable WHERE condition.
Noncompliant code example
DELETE FROM COUNTRIES.
Compliant solution
DELETE FROM COUNTRIES WHERE CODE = country_code.