The TRUNCATE TABLE statement
The TRUNCATE TABLE statement is another way to delete all rows from a table. Unlike the DELETE statement, SQL Server does not log individual row deletion in a transaction log. Therefore, this operation is not recoverable because when you run the TRUNCATE TABLE statement, SQL Server just logs page deallocations that occur as a result of this operation. The TRUNCATE TABLE statement is much faster when compared to the DELETE statement, with no WHERE clause, because it uses fewer system and database transaction log resources.
You cannot use the TRUNCATE TABLE statement on tables that are referenced by a foreign key constraint, included in an indexed view, or published for transactional or merge replication. In such a situation, ...
Get SQL Server 2014 Development Essentials now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
