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.

Property of



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" )