sp_ZapTable

Advantage SQL Engine

Removes all data from a table and re-indexes it.

Syntax

sp_ZapTable( TableName,CHARACTER,515 )

Parameters

TableName (I)

Name and/or path of a table to zap.

Remarks

sp_ZapTable performs a zap of a table which removes all records from the table and all data from the memo file 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_ZapTable 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

AdsZapTable (in the Advantage Client Engine)

sp_PackTable