Microsoft KB Archive/45590

= INF: Purpose of TRUNCATE TABLE =

Article ID: 45590

Article Last Modified on 12/3/2003

-

APPLIES TO


 * Microsoft SQL Server 4.21a Standard Edition
 * Microsoft SQL Server 6.0 Standard Edition
 * Microsoft SQL Server 6.5 Standard Edition
 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q45590





SUMMARY
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 KB45590

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.