15.10 - FOR data_table - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

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;