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

SQL Data Definition Language Detailed Topics
Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-24
dita:mapPath
jpx1556733107962.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1184
lifecycle
previous
Product Category
Teradata Vantage™

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