Table: ALL_REFS
Description of REF columns contained in tables accessible to the user
| Column Name | Description |
|---|---|
| COLUMN_NAME | Column name or attribute of object column |
| IS_SCOPED | Is the REF column scoped? |
| OBJECT_ID_TYPE | If ref contains user-defined OID, then USER-DEFINED, else if it contains system generated OID, then SYSTEM GENERATED |
| OWNER | Owner of the table containing the REF column |
| SCOPE_TABLE_NAME | Name of the scope table, if it exists |
| SCOPE_TABLE_OWNER | Owner of the scope table, if it exists |
| TABLE_NAME | Name of the table containing the REF column |
| WITH_ROWID | Is the REF value stored with the rowid? |