Static Data Dictionary Views, 82 of 452

ALL_SYNONYMS

ALL_SYNONYMS describes all synonyms accessible to the user.

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