ADM_TYPE_ATTRS

ADM_TYPE_ATTRS displays the attributes of the current database object type. By default, only the system administrator can access this view. Common users can access the view only after being authorized.

**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)	Determines whether the attribute is inherited from the super type (Y or N).