15.10 - DROP TABLE - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

Teradata Database
Release Number
Release Date
December 2015
Content Type
Programming Reference
Publication ID
English (United States)


Drops the definition for the specified table from the data dictionary and drops the object from its 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.

In this case, 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.

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.