15.10 - error_table_name - 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 new error table.

For information about naming database objects, see SQL Fundamentals, B035-1141.

If you do not explicitly specify an error table name, the system generates one in the form ET_data_table_name, where the characters ET_ are a literal string.

If data_table_name is longer than 27 characters, the system truncates it at the end and does not return a warning message.

The system returns an error message if the ET_data_table_name default name duplicates an existing table name. You can then specify an explicit unique error table name in place of the duplicate error table name.

database_name
user_name
Name of the database or user in which the error table is to be contained if not in the current database or user.

Example: Creating a Named Error Table

The following example creates an error table named e for data table t.

     CREATE ERROR TABLE e FOR t;

Example: Creating an Error Table for a Row-Level Security Table

The following example creates an error table named err_table_1 for the row-level security constraint-protected data table named table_1_RLS_constraints, but does not generate any row-level security columns for the error table because the request specifies the NO RLS option.

     CREATE ERROR TABLE err_table_1 FOR table_1_RLS_constraints 
       NO RLS;