USER_TYPES v16

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

NameTypeDescription
schema_nameTEXTName of the schema in which the type is defined.
type_nameTEXTName of the type.
type_oidOIDThe object identifier (OID) of the type.
typecodeTEXTThe typecode of the type. Possible values are: OBJECT, COLLECTION, OTHER.
attributesINTEGERNumber of attributes in the type.