Essential Books

DELETE all rows

suggest change

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.

Found a mistake? Have a question or improvement idea? Let me know.

Feedback about page:

Feedback:
Optional: your email if you want me to get back to you:

DELETE:
*DELETE
*DELETE all rows
*DELETE certain rows with WHERE
*TRUNCATE clause
*DELETE certain rows based upon comparisons with other tables
Table Of Contents