INF: Purpose of TRUNCATE TABLE

ID Number: Q45590

1.00 1.10 1.11 4.20

OS/2

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.s

Additional reference words: Transact-SQL