ADM_SYNONYMS

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

**Table 1** ADM_SYNONYMS columns
Name	Type	Description
owner	text	Owner of a synonym
schema_name	text	Name of the schema to which a synonym belongs
synonym_name	text	Name of a synonym
table_owner	text	Owner of an associated object Although the column is called table_owner, the associated object owned by the column 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 an 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 an 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.