ZeroFile

See Also: Erasefile

 

Purpose

To erase all data from a database table, leaving the empty table definition in place.

Syntax

zerofile table

What It Does

Zerofile erases all data from table (provided it is open) while maintaining the table definition unchanged. After a zerofile command, the number of records in table is zero.

zerofile customer

In this example, all record data in Database table customer is deleted. The table definition of customer remains intact for future use.

Once a zerofile command has been executed, the only way to restore the data is from a backup copy of the table.

Notes