The USER_TYPES view provides the information about all object types owned by the current user.

Parameter Type Description
Parameter Type Description
schema_name TEXT The name of the schema in which the type is defined.
type_name TEXT The name of the type.
type_oid OID The object identifier (OID) of the type.
typecode TEXT The typecode of the type. Valid values:
  • OBJECT
  • COLLECTION
  • OTHER
attributes INTEGER The number of properties in the type.