Drop a Table | Teradata Vantage - Dropping a Table - Analytics Database - Teradata Vantage

Database Administration

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-11-03
dita:mapPath
pgf1628096104492.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
ujp1472240543947
lifecycle
latest
Product Category
Teradata Vantageā„¢

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