SYSSYNONYMS
The syssynonyms system catalog table is unused.
The syssyntable table describes synonyms. The syssynonyms system
catalog table has the following columns.
| Column | Type | Explanation |
|---|---|---|
| owner | VARCHAR(32) | Name of the owner of the synonym |
| synname | VARCHAR(128) | Name of the synonym |
| created | DATE | Date when the synonym was created |
| tabid | INTEGER | Identifying code of a table, sequence, or view |
A composite index on the owner and synonym columns allows only unique values. The tabid column is indexed and allows duplicate values.