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.

Feedback about page:

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



Table Of Contents