The system table lists all direct dependencies between schema objects owned by the current user. 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 underlying objects have been changed and the view has not been accessed again yet.

Column Name Description
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
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