INF: Purpose of TRUNCATE TABLE (45590)
The information in this article applies to:
- Microsoft SQL Server 4.2x
- Microsoft SQL Server 6.0
- Microsoft SQL Server 6.5
- Microsoft SQL Server 7.0
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.
| Modification Type: | Major | Last Reviewed: | 12/3/2003 |
|---|
| Keywords: | kbother KB45590 |
|---|
|