Deletes a specified table.

Syntax

DELETE TABLE <filename> [[TYPE] PARADOX | DBASE]

<filename>

The name of the table that you want to delete.

[TYPE] PARADOX | DBASE

Specifies the type of table you want to delete, if <filename> does not include an extension. This option overrides the current SET DBTYPE setting. The TYPE keyword is included for readability only; it has no effect on the operation of the command.

Description

Use the DELETE TABLE command to delete a table and its index, memo, and other associated files. Make sure the table is not in use before you attempt to delete it.

OODML

Use the Database object’s dropTable( ) method.