DELETE all rows
suggest changeOmitting 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.
Found a mistake? Have a question or improvement idea?
Let me know.
Table Of Contents