17.10 - HELP COLUMN For a Data Table Or Error Table - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Detailed Topics

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1184-171K
Language
English (United States)

If you use either the FROM ERROR TABLE FOR data_table_name syntax or the example for the FROM error_table_name syntax, then the information returned is for the column you specify in the error table associated with data_table_name, not from the base table specified by data_table_name.

The HELP COLUMN information and attributes reported by either of these syntaxes is identical to that returned by the other HELP COLUMN syntaxes, only for an error table rather than for a base data table.

See CREATE ERROR TABLE for more information about error tables.

Also see HELP ERROR TABLE.