16.20 - FOR data_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
Content Type
Programming Reference
Publication ID
B035-1144-162K
Language
English (United States)
Last Update
2019-05-24

Name of the data table for which the error table to be dropped is defined.

This syntax is particularly useful if you did not define a name for the error table to be dropped and you do not know its system-assigned default name.

database_name
user_name
The containing database or user for the specified data table if it is defined in a database other than the current database.

Example: Dropping an Error Table

This example deletes the error table defined on the orders table.

     DROP ERROR TABLE FOR orders;