15.10 - data_table_name - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Release Number
15.10
Published
December 2015
Content Type
Programming Reference
Publication ID
B035-1144-151K
Language
English (United States)
Last Update
2018-06-05

data_table_name

Name of the data table for which this error table is being created.

data_table_name cannot specify a nonpartitioned NoPI table.

The name must correspond to either a permanent base data table or a queue table. Otherwise, the system returns an error message to the requestor.

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

Example: Creating an Error Table with a Default Name

The following example creates an error table with a default name of et_t for data table t.

     CREATE ERROR TABLE FOR t;