ALL_SYNONYMS

ALL_SYNONYMS describes all synonyms accessible to the current user.

Related Views

• DBA_SYNONYMS describes all synonyms in the database.
• USER_SYNONYMS describes all synonyms owned by the current user. This view does not display the OWNER column.

  Column	Datatype	NULL	Description
  OWNER	VARCHAR2(30)	NOT NULL	Owner of the synonym
  SYNONYM_NAME	VARCHAR2(30)	NOT NULL	Name of the synonym
  TABLE_OWNER	VARCHAR2(30)		Owner of the object referenced by the synonym
  TABLE_NAME	VARCHAR2(30)	NOT NULL	Name of the object referenced by the synonym
  DB_LINK	VARCHAR2(128)		Name of the database link referenced, if any