15.10 - data_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

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;