SYSSYNONYMS

The syssynonyms system catalog table is unused. The syssyntable table describes synonyms. The syssynonyms system catalog table has the following columns.
Table 1. SYSSYNONYMS table column descriptions

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.