Topic group Related topics
Deletes all the rows in a table.
<oRef>.emptyTable(<table name expC>)
The database in which the table exists.
<table name expC>
The name of the table you want to empty.
emptyTable( ) deletes all of the rows in a table, leaving an empty table structure, as if the table was just created. emptyTable( ) does not ask for confirmation; the deletion is immediate. The table cannot be open anywhere at the time of the emptyTable( ); if it is, emptyTable( ) fails.
To empty a Standard table, you can always use the default database in the default session by referring to it through the databases array property of the _app object. For example,
_app.databases[ 1 ].emptyTable( "YtdSales" )