11. OpenSQL Standard Catalogs : Standard Catalog Interface : The iisynonyms Catalog
 
Share this page                  
The 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.