16.20 - View Attributes - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Detailed Topics

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1184-162K
Language
English (United States)

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
  • With an explicit format, DATE.
  • With an implicit format created in ANSIDATE mode, ‘YYYY/MM/DD’.
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.
  • N specifies NOT NULL.
  • Y specifies 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.
  • B specifies that column attributes for both UPPERCASE and CASESPECIFIC are defined.
  • C specifies that the column attributes for CASESPECIFIC is defined.
  • N specifies that column attributes for neither UPPERCASE nor CASESPECIFIC are defined.
  • U specifies that the column attributes for UPPERCASE is defined.
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.
  • 1 specifies LATIN server character data type columns.
  • 2 specifies UNICODE server character data type columns.
  • 3 specifies KANJISJIS server character data type columns.
  • 4 specifies GRAPHIC server character data type columns.
  • 5 specifies KANJI1 server 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.
  • GA specifies Generated Always.
  • GD specifies Generated by Default.
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.
  • N specifies that the column is non-temporal.
  • R specifies that the column is part of a temporal relationship constraint.
  • T specifies that the column has TRANSACTIONTIME column.
  • V specifies that the column has VALIDTIME column.

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