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