16.20 - Attributes Reported by the ATTRIBUTE Option - 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 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