DROP TABLE

Enterprise Edition Home | Express Edition Home | Previous Page | Next Page SQL Statements >

DROP TABLE

Use the DROP TABLE statement to remove a table with its associated indexes and data. This statement is an extension to the ANSI/ISO standard for SQL.

Syntax

                                           .-CASCADE--.
>>-DROP TABLE--+-----------+--+-table---+--+-RESTRICT-+--------><
               '- owner--.-'  '-synonym-'

Element	Description	Restrictions	Syntax
owner	Name of table owner	Must own the table	Owner Name
synonym	Local synonym for a table that is to be dropped	The synonym and its table must exist, and USERTABLENAME must not be set to `1`	Identifier
table	Name of a table to drop	Must be registered in the systables system catalog table of the local database	Identifier

Usage

You must be the owner of the table or have the DBA privilege to use the DROP TABLE statement.

You cannot drop an Extended Parallel Server table that includes a dependent GK index unless that index is entirely dependent on the affected table.

If you issue a DROP TABLE statement, DB–Access does not prompt you to verify that you want to delete an entire table.