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).