USER_DEPENDENCIES¶
The USER_DEPENDENCIES view provides information about dependencies
between objects owned by a current user (with the except of synonyms).
Name |
Type |
Description |
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. |
schemaid |
NUMERIC |
ID of the current schema. |
dependency_type |
CHARACTER VARYING(4) |
Included for compatibility only. Always set to HARD. |
