USER_DEPENDENCIES v17

The USER_DEPENDENCIES view provides information about dependencies between objects owned by a current user, with the exception 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 only for compatibility. Always NULL.
schemaidNUMERICID of the current schema.
dependency_typeCHARACTER VARYING(4)Included only for compatibility. Always set to HARD.