16.20 - DROP TABLE - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-24
dita:mapPath
wkf1512081455740.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

Purpose

Drops the definition for a specified table from the Data Dictionary and from the 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.

Syntax