INF: Purpose of TRUNCATE TABLE

ID: Q45590

The information in this article applies to:

Microsoft SQL Server version 4.2 for OS/2

TRUNCATE TABLE deallocates all of the pages, both data and index, assigned to a table by using the allocation bitmaps. This is much faster than following the page chain and deleting each row, especially if indexes are involved.

Additional query words: Transact-SQL


Keywords          : kbother SSrvServer 
Version           : 4.2
Platform          : OS/2 
Issue type        :

Last Reviewed: March 6, 1999