emptyTable( )

Topic group Related topics

Deletes all the rows in a table.

Syntax

<oRef>.emptyTable(<table name expC>)

<oRef>

The database in which the table exists.

<table name expC>

The name of the table you want to empty.

Property of

Database

Description

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