CREATE ERROR TABLE SQL Statement | VantageCloud Lake - CREATE ERROR TABLE - Teradata VantageCloud Lake

Defines the name and containing database of a new error table and specifies the name of the associated data table.

If the associated data table is column-partitioned, Vantage creates the error table like a non-column-partitioned table except that the error table is a NoPI table without partitioning.

• CREATE ERROR TABLE Syntax
• CREATE ERROR TABLE Syntax Elements
• CREATE ERROR TABLE Usage Notes
• CREATE ERROR TABLE Examples
• CREATE ERROR TABLE Related Information

ANSI Compliance

This statement is a Teradata extension to the ANSI SQL:2011 standard.

Other SQL dialects support similar non-ANSI standard statements with names such as START VIOLATIONS TABLE.

Required Privileges

You must have the CREATE TABLE privilege on the database or user in which the error table is created.

Privileges Granted Automatically