16.10 - Dropping a Table - Teradata Database

Teradata Database Administration

Teradata Database
Release Number
Release Date
April 2018
Content Type
Publication ID
English (United States)

Use one of the following statements to drop a table:

Table You Want To Remove Statement To Use
Permanent data table DROP TABLE.

Dropping a table does not delete the views, macros, functions or stored procedures that referenced the dropped table. You need to explicitly drop or alter the reference.

You cannot drop a table defined with a trigger, hash index, or join index. First drop the index or trigger and then drop the table.

Materialized global temporary table, before session end DROP TEMPORARY TABLE.
Teradata Database automatically drops all materialized temporary tables at session end.
Volatile table before session end DROP TABLE.
Global temporary table definition DROP TABLE.