17.10 - error_table_name_specification - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1144-171K
Language
English (United States)
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.
error_table_name
Name of the new error table.
For information about naming database objects, see Teradata Vantage™ - 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.