The columns or parameters are listed in the order in which they were defined.
The attributes are returned as shown in the following table.
Attribute | Data Type | Nullable? | Comments |
---|---|---|---|
Column Name | VARCHAR(30) | No | The name of a column in the view specified in the HELP VIEW request. Interpret as the equivalent of CF, or CHARACTER(n) data type. When DATEFORM=ANSIDATE, this column should be described externally as CHARACTER(10). Format characteristics
The attributes listed in this table are returned for each column in the view.
|
Type | CHARACTER(2) | Yes | The data type for the Column Name. See Data Type Codes for a list of the data type codes and their meanings. |
Comment | VARCHAR (255) | Yes | The contents of the optional comment field for the view, if a comment was created |
Nullable | CHARACTER | Yes | Indicates whether the column name column is nullable.
|
Format | CHARACTER(30) | Yes | This column is always null for views. |
Title | VARCHAR (60) | Yes | The title of the column, if a title exists. |
Max Length | INTEGER | Yes | HELP VIEW requests do not return a Max Length value. |
Decimal Total Digits | SMALLINT | Yes | If type is DECIMAL. For INTERVAL types, returns a value from 1–4 representing the number of digits in the leading field of the interval (number of non-fractional digits for INTERVAL SECOND). This column is null for TIME and TIMESTAMP data types. |
Decimal Fractional Digits | SMALLINT | Yes | This column is always null for views. |
Range Low | FLOAT | Yes | Always null. BETWEEN clause is included in column constraint. |
Range High | FLOAT | Yes | Always null. BETWEEN clause is included in column constraint. |
Uppercase | CHARACTER | Yes | If type is CHARACTER or VARCHAR, defines UPPERCASE and CASESPECIFIC attributes for the column.
|
Table/View? | CHARACTER | No | Object type. HELP VIEW requests always return a value of V for view. |
Default Value | VARCHAR (255) | Yes | Returns the default value (as text) for the parameter. The value is null if there is no default value. |
Character Type | SMALLINT | Yes | Returns the type of the different character data type columns.
If the data type for a column is not CHARACTER, this attribute returns null. |
IDCol Type | CHARACTER(2) | Yes | Returns a code for the type of identity column.
|
UDT Name | VARCHAR(61) | Yes | This column is always null. |
Temporal Column | CHARACTER(2) | Yes | Reports whether a column is temporal or not and if it is part of a Temporal Relationship constraint.
For information about temporal columns, see Teradata Vantage™ - ANSI Temporal Table Support, B035-1186 and Teradata Vantage™ - Temporal Table Support, B035-1182. |
Current ValidTime Unique? | CHARACTER(2) | Yes | Reports whether a column is a UNIQUE Current VALIDTIME column or not. For information about temporal columns, see Teradata Vantage™ - ANSI Temporal Table Support, B035-1186 and Teradata Vantage™ - Temporal Table Support, B035-1182. |
Sequenced ValidTime Unique? | CHARACTER(2) | Yes | Reports whether a column is a UNIQUE Sequenced VALIDTIME column or not. For information about temporal columns, see Teradata Vantage™ - ANSI Temporal Table Support, B035-1186 and Teradata Vantage™ - Temporal Table Support, B035-1182. |
NonSequenced ValidTime Unique? | CHARACTER(2) | Yes | Reports whether a column is a UNIQUE Nonsequenced VALIDTIME column or not. For information about temporal columns, see Teradata Vantage™ - ANSI Temporal Table Support, B035-1186 and Teradata Vantage™ - Temporal Table Support, B035-1182. |
Current TransactionTime Unique? | CHARACTER(2) | Yes | Reports whether a column is a UNIQUE Current TRANSACTIONTIME column or not. For information about temporal columns, see Teradata Vantage™ - ANSI Temporal Table Support, B035-1186 and Teradata Vantage™ - Temporal Table Support, B035-1182. |
Column Dictionary Name | VARCHAR(128) | No | The attributes shown in this section are based upon and supersede the corresponding older attributes, Column Name and Title, while providing additional functionality. The older attributes are retained for compatibility with existing applications. For details, see the topics beginning with Object Name and Title Data in HELP Reports. The system reports these attributes for each column in the view. |
Column SQL Name | VARCHAR(644) | No | |
Column Uescape | VARCHAR(1) | Yes | |
Dictionary Title | VARCHAR(256) | Yes | |
SQL Title | VARCHAR(1256) | Yes | |
Title Uescape | VARCHAR(1) | Yes |