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 |
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 |