Contains one row for each attribute (including inherited attributes where
applicable) that is defined for a user-defined structured data type.
Table 101. OBJCAT.ATTRIBUTES Catalog View
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| TYPESCHEMA | CHAR(8) |
| Qualified name of the strucutred data type that includes the attribute. |
| TYPENAME | VARCHAR(18) |
| |
| ATTR_NAME | VARCHAR(18) |
| Attribute name. |
| ATTR_TYPESCHEMA | CHAR(8) |
| Contains the qualified name of the type of the attribute. |
| ATTR_TYPENAME | VARCHAR(18) |
| |
| TARGET_TYPESCHEMA | CHAR(8) |
| Qualified name of the target type, if the type of the attribute is REFERENCE. Null value if the type of the attribute is not REFERENCE. |
| TARGET_TYPENAME | VARCHAR(18) |
| |
| ORIGIN_TYPESCHEMA | CHAR(8) |
| Qualified name of the data type in the data type hierarchy where the attribute was introduced. |
| ORIGIN_TYPENAME | VARCHAR(18) |
| |
| POSITION | SMALLINT |
| Position of the attribute in the definition of the structured data type starting with zero. |
| LENGTH | INTEGER |
| Maximum length of data. 0 for distinct types. The LENGTH column indicates precision for DECIMAL fields. |
| SCALE | SMALLINT |
| Scale for DECIMAL fields; 0 if not DECIMAL. |
| CODEPAGE | SMALLINT |
| Code page of the attribute. For character-string attributes not defined with FOR BIT DATA, the value is the database code page. For graphic-string attributes, the value is the DBCS code page implied by the (composite) database code page. Otherwise, the value is 0. |
| LOGGED | CHAR(1) |
| Applies only to attributes whose type is LOB or distinct based on LOB
(blank otherwise).
Y=Attribute is logged. N=Attribute is not logged. |
| COMPACT | CHAR(1) |
| Applies only to attributes whose type is LOB or distinct based on LOB
(blank otherwise).
Y=Attribute is compacted in storage. N=Attribute is not compacted. |
| DL_FEATURES | CHAR(10) |
| Applies to DATALINK type attributes only. Blank for REFERENCE type attributes. Null otherwise. Encodes various DATALINK features such as linktype, control mode, recovery, and unlink properties. |