SQL Server TSQL Delete All Table Rows – TRUCATE TABLE vs DELETE ALL

By /

Use the TRUNCATE TABLE command instead of DELETE ALL FROM [table] if you need to remove all records:

TRUNCATE TABLE Employee;

/* instead of */

DELETE ALL FROM Employee;

The TRUNCATE command will, in most cases,take less time than DELETE especially for large tables.

WHY?

TRUNCATE doesn’t log each deleted row in the transaction log while DELETE does.

Scroll to Top