USER_DEPENDENCIES v12

The USER_DEPENDENCIES view provides information about dependencies between objects owned by a current user (with the except of synonyms).

NameTypeDescription
schema_nameCHARACTER VARYING(128)Name of the schema in which the dependent object resides.
nameCHARACTER VARYING(128)Name of the dependent object.
typeCHARACTER VARYING(18)Type of the dependent object.
referenced_ownerCHARACTER VARYING(128)Owner of the referenced object.
referenced_schema_nameCHARACTER VARYING(128)Name of the schema in which the referenced object resides.
referenced_nameCHARACTER VARYING(128)Name of the referenced object.
referenced_typeCHARACTER VARYING(18)Type of the referenced object.
referenced_link_nameCHARACTER VARYING(128)Included for compatibility only. Always NULL.
schemaidNUMERICID of the current schema.
dependency_typeCHARACTER VARYING(4)Included for compatibility only. Always set to HARD.