DELETE statements should contain
WHERE clauses to keep the modification of records under control.
Otherwise unexpected data loss could result.
Noncompliant Code Example
DELETE FROM countries
UPDATE employee SET status = 'retired' FROM table1 AS employee
TRUNCATE TABLE countries
DELETE FROM countries WHERE CODE = @country_code
UPDATE employee SET status = 'retired' FROM table1 AS employee WHERE age > @maxAge
No issue is reported for statements made on temporary tables.