The system table lists all direct dependencies between schema objects to which the current user has access. All users have access to the table.
Dependencies between scripts cannot be determined. In case of a view, entries with REFERENCE_TYPE=NULL values can be shown, if the underlying objects have been changed and the view has not been accessed yet.
Column | Meaning |
---|---|
OBJECT_SCHEMA | Schema of object |
OBJECT_NAME | Name of object |
OBJECT_TYPE | Type of object |
OBJECT_OWNER | Owner of the object |
OBJECT_ID | ID of the object |
REFERENCE_TYPE | Reference type (VIEW, CONSTRAINT) |
REFERENCED_OBJECT_SCHEMA | Schema of the referenced object |
REFERENCED_OBJECT_NAME | Name of the referenced object |
REFERENCED_OBJECT_TYPE | Type of the referenced object |
REFERENCED_OBJECT_OWNER | Owner of the referenced object |
REFERENCED_OBJECT_ID | ID of the referenced object |