Drops the definition for a specified table from the Data Dictionary and from the containing database or user, depending on the keyword specified.
You can drop a base table or materialized global temporary table, depending on the keyword specified.
| Keyword Specified | Database Object Dropped |
|---|---|
| TABLE | Base table definition and all table rows. The definition of a base table is restricted to persistent base tables, queue tables, and volatile tables. Also, drops definition of global temporary table (if TEMPORARY keyword is not specified). To drop a materialized global temporary table, you must specify the keyword TEMPORARY. |
| TEMPORARY TABLE | Materialized global temporary table. |
To drop a data table that has an associated error table, you must first drop its error table. See DROP ERROR TABLE.
- DROP TABLE Syntax
- DROP TABLE Syntax Elements
- DROP TABLE Usage Notes
- DROP TABLE Examples
- Table Headers (for information about the Dropped flag)
ANSI Compliance
DROP TABLE is ANSI SQL:2011-compliant.
Required Privileges
You must have the appropriate DROP privilege on the specified base table or queue table.
You do not need the DROP privilege to drop materialized global temporary or volatile tables.