DROP TABLE and Error Tables - Analytics Database - Teradata Vantage

SQL Data Definition Language Detailed Topics

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-07-11
dita:mapPath
vuk1628111288877.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
B035-1184
lifecycle
latest
Product Category
Teradata Vantage™

You cannot drop an error table using the DROP TABLE statement. You must use DROP ERROR TABLE.

To drop a data table has an error table associated with it, you must first drop its error table.

You must drop the error table in a separate DROP ERROR TABLE request. See Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144.

The system adds a row to the DBC.ErrorTbls system table only when you create an error table, so you do not need to delete any rows from DBC.ErrorTbls when you drop its associated data table.

The DBC.ErrorTblsV or DBC.ErrorTblsVX views displays Dropped Database, Dropped Table, or Dropped User, respectively, in place of the dropped database, data table, or error table creator name. See Teradata Vantage™ - Data Dictionary, B035-1092.