ADM_TYPE_ATTRS

ADM_TYPE_ATTRS displays the attributes of the current database object type.

**Table 1** ADM_TYPE_ATTRS columns
Name	Type	Description
OWNER	oid	Owner of the type
TYPE_NAME	name	Data type name
ATTR_NAME	name	Column name
ATTR_TYPE_MOD	integer	Type-specific data supplied at the table creation time (for example, the maximum length of a varchar column). This column is used as the third parameter when passing to type-specific input functions and length coercion functions. The value will generally be –1 for types that do not need ATTTYPMOD.
ATTR_TYPE_OWNER	oid	Owner of an attribute of this type
ATTR_TYPE_NAME	name	Data type attribute name
LENGTH	smallint	Number of bytes in the internal representation of the type for a fixed-size type. It is a negative number for a variable-length type. ● The value –1 indicates a "varlena" type (one that has a length word). ● The value –2 indicates a null-terminated C string.
PRECISION	integer	Precision of the numeric type
SCALE	integer	Range of the numeric type
CHARACTER_SET_NAME	character(1)	Character set name of an attribute (c or n)
ATTR_NO	smalllint	Attribute number
INHERITED	character(1)	Specifies whether the attribute is inherited from the super type (Y or N).