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

SQL Data Definition Language Detailed Topics

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
imq1591724555718.ditamap
dita:ditavalPath
imq1591724555718.ditaval
dita:id
B035-1184
lifecycle
previous
Product Category
Teradata Vantage™

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.