ADM_SYNONYMS

ADM_SYNONYMS displays all synonyms in the database. This view is accessible only to system administrators. This view exists in the PG_CATALOG and SYS schemas.

**Table 1** ADM_SYNONYMS columns
Name	Type	Description
owner	text	Owner of a synonym
schema_name	text	Name of the schema to which the synonym belongs
synonym_name	text	Synonym name
table_owner	text	Owner of the associated object. Although the column is called table_owner, the associated object is not necessarily a table. It can be any common database object, such as a view, stored procedure, or synonym.
table_name	text	Name of the associated object. Although the column is called table_name, the associated object is not necessarily a table. It can be any common database object, such as a view, stored procedure, or synonym.
table_schema_name	text	Schema name of the associated object. Although the column is called table_schema_name, the associated object is not necessarily a table. It can be any common database object, such as a view, stored procedure, or synonym.