Navigation:  Advantage SQL > System Procedures > Procedures >

sp_PackTable

Advantage SQL Engine

Previous pageReturn to chapter overviewNext page

Removes all deleted records from a table and re-indexes it.

Syntax

sp_PackTable( TableName,CHARACTER,515 )

 

sp_PackTable( TableName,CHARACTER,515,

             MemoBlockSize,INTEGER )

 

Parameters

TableName (I)

Name and/or path of a table to pack.

MemoBlockSize (I)

Optional memo block size. If this is not provided or if the value is 0, the memo block size will not be changed by the pack operation.

Remarks

sp_PackTable performs a pack of a table which removes all deleted records from the table. Internal fragmentation in memo files will also be eliminated. It then re-indexes the table. This operation requires exclusive access to the table, no process can have this table open when calling this procedure. Only auto-open indexes will be re-indexed. sp_PackTable is illegal in a transaction. The TableName parameter must specify the table name of a dictionary bound table, or the table path of a free table.

See Also

AdsPackTable

sp_PackTableOnline

sp_ZapTable