ALL_DEPENDENCIES v16
The ALL_DEPENDENCIES view provides information about the dependencies between database objects that the current user can access, except for synonyms.
| Name | Type | Description |
|---|---|---|
owner | CHARACTER VARYING(128) | Owner of dependent object. |
schema_name | CHARACTER VARYING(128) | Name of the schema in which the dependent object resides. |
name | CHARACTER VARYING(128) | Name of the dependent object. |
type | CHARACTER VARYING(18) | Type of the dependent object. |
referenced_owner | CHARACTER VARYING(128) | Owner of the referenced object. |
referenced_schema_name | CHARACTER VARYING(128) | Name of the schema in which the referenced object resides. |
referenced_name | CHARACTER VARYING(128) | Name of the referenced object. |
referenced_type | CHARACTER VARYING(18) | Type of the referenced object. |
referenced_link_name | CHARACTER VARYING(128) | Included for compatibility only. Always NULL. |
dependency_type | CHARACTER VARYING(4) | Included for compatibility only. Always set to HARD. |