Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
ZAP Command
Collapse the table of content
Expand the table of content

ZAP Command

Visual Studio .NET 2003

Removes all records from a table, leaving just the table structure.

ZAP   [IN nWorkArea | cTableAlias]


IN nWorkArea
Specifies the work area of the table in which all records are removed.
IN cTableAlias
Specifies the alias of the table in which all records are removed.

If you omit nWorkArea and cTableAlias, all records are removed in the table in the currently selected work area.


Issuing ZAP is equivalent to issuing DELETE ALL followed by PACK, but ZAP is much faster.

If SET SAFETY is ON, Microsoft Visual FoxPro asks if you would like to remove the records from the current table.

Issuing ZAP does not cause a Delete trigger to occur. For more information about creating triggers for a table, see CREATE TRIGGER.

Caution   Records zapped from the current table cannot be recalled.

See Also


© 2015 Microsoft