ADM_TYPE_ATTRS

ADM_TYPE_ATTRS displays the attributes of the current database object type. By default, only users with the SYSADMIN permission can access this system view. Common users can access it 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)	Specifies whether the attribute is inherited from the super type (Y or N).