CREATE ERROR TABLE Examples | Teradata Vantage - 17.10 - CREATE ERROR TABLE Examples - 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)

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;
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;