Dropping a Table - Teradata Database

TO remove a …

USE this statement …

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.

Note: Teradata Database automatically drops all materialized temporary tables at session end.

volatile table before session end

DROP TABLE.

global temporary table definition

DROP TABLE.