INF: Purpose of TRUNCATE TABLE

ID: Q45590

The information in this article applies to:

Microsoft SQL Server versions 4.2x, 6.0, 6.5, 7.0

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 :