Static Data Dictionary Views, 71 of 452

ALL_REFS

ALL_REFS describes the REF columns and REF attributes in object type columns accessible to the current user.

Related views:

DBA_REFS describes all REF columns and REF attributes in the database.

USER_REFS describes the REF columns and REF attributes in object type columns owned by the current user. This view does not display the OWNER column.

Column Datatype NULL Description

OWNER

VARCHAR2(30)

NOT NULL

Name of the owner

TABLE_NAME

VARCHAR2(30)

NOT NULL

Name of the table

COLUMN_NAME

VARCHAR2(4000)

Name of the REF column or attribute. If it is not a top-level attribute, the value of COLUMN_NAME should be a path name starting with the column name

WITH_ROWID

VARCHAR2(3)

Whether the REF value is stored with ROWID (YES or NO)?

IS_SCOPED

VARCHAR2(3)

Whether the REF column is scoped (YES or NO)?

SCOPE_TABLE_OWNER

VARCHAR2(30)

Name of the owner of the scope table, if it exists and is accessible by the user

SCOPE_TABLE_NAME

VARCHAR2(30)

Name of the scope table, if it exists and is accessible by the user

OBJECT_ID_TYPE

VARCHAR2(16)

If user-defined OID, then USER-DEFINED, else if system generated OID, then SYSTEM GENERATED

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(30)`	`NOT NULL`	Name of the owner
`TABLE_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the table
`COLUMN_NAME`	`VARCHAR2(4000)`		Name of the REF column or attribute. If it is not a top-level attribute, the value of `COLUMN_NAME` should be a path name starting with the column name
`WITH_ROWID`	`VARCHAR2(3)`		Whether the REF value is stored with ROWID (`YES` or `NO`)?
`IS_SCOPED`	`VARCHAR2(3)`		Whether the REF column is scoped (`YES` or `NO`)?
`SCOPE_TABLE_OWNER`	`VARCHAR2(30)`		Name of the owner of the scope table, if it exists and is accessible by the user
`SCOPE_TABLE_NAME`	`VARCHAR2(30)`		Name of the scope table, if it exists and is accessible by the user
`OBJECT_ID_TYPE`	`VARCHAR2(16)`		If user-defined OID, then `USER-DEFINED`, else if system generated OID, then `SYSTEM GENERATED`