dropTable( )

Topic group Related topics

Deletes (drops) a table from a database.

Syntax

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

<oRef>

The database in which the table exists.

<table name expC>

The name of the table you want to delete.

Property of

Database

Description

dropTable( ) deletes a table and any existing secondary files, like memo files and indexes. dropTable( ) does not ask for confirmation; the deletion is immediate. The table cannot be open anywhere at the time of the dropTable( ); if it is, dropTable( ) fails.

To delete 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 ].dropTable( "Temp" )