CREATE ERROR TABLE in Teradata

Defines the name and containing database of a new error table and specifies the name of the data table with which it is associated.

Syntax:
CREATE ERROR TABLE error_table_name FOR database_name.table_name ;


Example 1
The following example creates an error table with a default name of et_t for data table t.
CREATE ERROR TABLE FOR t;


Example 2
The following example creates an error table named e for data table t.
CREATE ERROR TABLE e FOR t;