Drop a Table | Teradata Vantage - 17.00 - 17.05 - Dropping a Table - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Database Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
17.05
Published
June 2020
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
rgu1556127906220.ditamap
dita:ditavalPath
lze1555437562152.ditaval

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.
Advanced SQL Engine automatically drops all materialized temporary tables at session end.
Volatile table before session end DROP TABLE.
Global temporary table definition DROP TABLE.