MY_TYPE_ATTRS

YES: It is inherited from a supertype.
NO: It is not inherited from a supertype.

MY_TYPE_ATTRS displays all types of attributes owned by the current user in the database. This view exists in the PG_CATALOG and SYS schemas and all users can access this view.

**Table 1** MY_TYPE_ATTRS columns
Name	Type	Description
type_name	character varying(128)	Data type name.
attr_name	character varying(128)	Attribute name.
attr_type_mod	character varying(7)	Type modifier of an attribute: REF POINT
attr_type_owner	character varying(128)	Owner of an attribute type.
attr_type_name	character varying(128)	Name of an attribute type.
length	numeric	Length of the CHAR attribute, or the maximum length of the VARCHAR and character varying attribute
precision	numeric	Decimal precision of a number or DECIMAL attribute, or binary precision of a FLOAT attribute.
scale	numeric	Decimal places for a numeric or DECIMAL attribute.
character_set_name	character varying(44)	Character set name of an attribute (Char_CS or NCHAR_CS).
attr_no	numeric	Syntax order number or location (not used as an ID number) of an attribute specified in the type specification or CREATE TYPE statement.
inherited	character varying(3)	Specifies whether an attribute is inherited from a supertype. YES: It is inherited from a supertype. NO: It is not inherited from a supertype.