SQL DELETE all rows


Example

Omitting a WHERE clause will delete all rows from a table.

DELETE FROM Employees

See TRUNCATE documentation for details on how TRUNCATE performance can be better because it ignores triggers and indexes and logs to just delete the data.