DROP TABLE

Removes a table from the database.

SYNTAX

DESCRIPTION

The DROP TABLE command removes an existing table from the database. To execute the DROP TABLE command you must be the table owner, or have DBA or SYSADM security privileges.

When you drop a table, DBMaker will also drop all indexes and primary keys on the table. If the table has a primary key which is referenced by one or more foreign keys, you must drop all foreign keys that reference the primary key before you can drop the table. You cannot drop any system tables.

EXAMPLE

The following example drops the Employees table from the database.

DROP TABLE Employees

RELATED COMMANDS

• CREATE TABLE
• ALTER TABLE ADD COLUMN
• ALTER TABLE DROP COLUMN
• ALTER TABLE MODIFY COLUMN

< DROP SYNONYM | Contents | DROP TABLESPACE >