15.00 - Attributes Reported by the ATTRIBUTE Option - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

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

Attributes Reported by the ATTRIBUTE Option

The attributes reported by this option are generally identical to those reported by HELP COLUMN (see “HELP COLUMN” on page 908 for the definitions of those attributes). The following table lists only those attributes that are unique to the HELP TYPE … ATTRIBUTE option.

 

Attribute

Data Type

Nullable?

Description

Attribute Name

VARCHAR(30)

Yes

  • If the UDT is a structured type, reports the name of one of its attributes.
  • If the UDT is a distinct type, reports null.
  • Max Length

    INTEGER formatted as -(10)9

    Yes

  • If the attribute is a UDT or ARRAY/VARRAY type, reports the maximum transformed length of its external data type.
  • If no transform group is defined for the UDT, reports null.
  • Format

    VARCHAR(30)

    Yes

  • If the attribute is a UDT or ARRAY/VARRAY type, reports the format associated with its fromsql transform.
  • If no fromsql transform is defined for the UDT, reports null.
  • UDT Name

    VARCHAR(61)

    Yes

  • If the attribute is a UDT or ARRAY/VARRAY type, reports its name.
  • If the attribute is not a UDT or ARRAY/VARRAY type, reports null.
  • Decimal Total Digits

    SMALLINT

    Yes

  • If the attribute is a UDT or ARRAY/VARRAY type whose underlying data type is numeric, reports the total number of digits for the underlying type.
  • If the attribute is not a UDT or ARRAY/VARRAY type, reports null.
  • Decimal Fractional Digits

    SMALLINT

    Yes

  • If the attribute is a UDT or ARRAY/VARRAY type whose underlying data type is numeric, reports the total number of fractional digits for the underlying type.
  • If the attribute is not a UDT or ARRAY/VARRAY type, reports null.
  • Attribute Dictionary Name

    VARCHAR(128)

    No

    The attributes shown in this section are based upon and supersede the corresponding older attributes, Attribute Name and UDT Name, 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.

    Attribute SQL Name

    VARCHAR(644)

    No

    Attribute Name Uescape

    VARCHAR(1)

    Yes

    UDT Database Dictionary Name

    VARCHAR(128)

    No

    UDT Database SQL Name

    VARCHAR(644)

    No

    UDT Database Uescape Name

    VARCHAR(1)

    Yes

    UDT Dictionary Name

    VARCHAR(128)

    No

    UDT SQL Name

    VARCHAR(644)

    No

    UDT Name Uescape

    VARCHAR(1)

    Yes