17.10 - Attributes Reported by the ATTRIBUTE Option - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Detailed Topics

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1184-171K
Language
English (United States)

The attributes reported by this option are generally identical to those reported by HELP COLUMN (see HELP COLUMN 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 Object Name and Title Data in HELP Reports.

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