OpenSQL Reference Guide > OpenSQL Reference Guide > OpenSQL Standard Catalogs > Standard Catalog Interface > iisynonyms Catalog
Was this helpful?
iisynonyms Catalog
The iisynonyms catalog contains information about the synonyms that have been defined for the database. Entries appear in iisynonyms when a create synonym statement is issued. Entries are removed when a drop synonym statement is issued for an existing synonym, or when a drop table|view|index statement drops the table on which the synonym is defined.
Column Name
Data Type
Description
synonym_name
char(256)
The name of the synonym.
synonym_owner
char(32)
The owner of the synonym.
table_name
char(256)
The name of the table, view or index for which the synonym was created.
table_owner
char(32)
The owner of the table.
Last modified date: 08/28/2024