DROP TABLE Statement

Deletes an SQL table.

Syntax

DROP TABLE base-table-name

Syntax Element

base-table-name =
{owner-name.}base-table-identifier

owner-name
The SQL user-id of the creator of the table.

base-table-identifier
The name of the required table.

Restrictions

Only the SQL owner of the table can perform this statement. The owner of the table must have SQL Catalog Maintenance privilege set in the Reality security profile.

Comments

Only the catalog entries for the table will be deleted if the table was not created with the SQL CREATE TABLE statement.

The underlying Reality file and indexes will be deleted if the table was created with the SQL CREATE TABLE statement.

Example

DROP TABLE EMP