15.00 - HELP VIEW - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

prodname
Teradata Database
vrm_release
15.00
category
Programming Reference
featnum
B035-1184-015K

HELP VIEW

View Attributes

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’
  • Note: 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” on page 901 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 ANSI Temporal Table Support and Temporal Table Support.

    Current ValidTime Unique?

    CHARACTER(2)

    Yes

    Reports whether a column is a UNIQUE Current VALIDTIME column or not.

    For information about temporal columns, see ANSI Temporal Table Support and Temporal Table Support.

    Sequenced ValidTime Unique?

    CHARACTER(2)

    Yes

    Reports whether a column is a UNIQUE Sequenced VALIDTIME column or not.

    For information about temporal columns, see ANSI Temporal Table Support and Temporal Table Support.

    NonSequenced ValidTime Unique?

    CHARACTER(2)

    Yes

    Reports whether a column is a UNIQUE Nonsequenced VALIDTIME column or not.

    For information about temporal columns, see ANSI Temporal Table Support and Temporal Table Support.

    Current TransactionTime Unique?

    CHARACTER(2)

    Yes

    Reports whether a column is a UNIQUE Current TRANSACTIONTIME column or not.

    For information about temporal columns, see ANSI Temporal Table Support and Temporal Table Support.

    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 “Working with Object Name and Title Data in HELP Reports” on page 896.

    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