DROP TABLE command

This command removes a base table.

Syntax

DROP TABLE table_name;
Keyword Description
table_name Name of the table to remove

Use

This statement is used to remove the same kinds of tables that are created with a CREATE TABLE statement. To drop views, use the DROP VIEW statement. To drop a table, you must own the schema in which the table resides or have (database administrator) DBA privileges.

The definition of the table is eliminated and all users lose their privileges on that table.

Example

DROP TABLE STAFF
Parent topic: SQL Commands
Related reference
CREATE TABLE Command