15.00 - HELP COLUMN For a Data Table Or Error Table - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

Teradata Database
Programming Reference

HELP COLUMN For a Data Table Or Error Table

If you use either the FROM ERROR TABLE FOR data_table_name syntax (see the examples for HELP COLUMN in SQL Data Definition Language) or the example for the FROM error_table_name syntax (see HELP COLUMN in SQL Data Definition Language), 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.

To retrieve help information for columns defined for data_table_name, you must use one of the syntaxes defined by HELP COLUMN “Syntax 1” through “Syntax 5” in SQL Data Definition Language.

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” on page 228 for more information about error tables.

Also see “HELP ERROR TABLE” on page 924.