EXA_ALL_DEPENDENCIES

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