Home | Previous Page | Next Page   System Catalog Tables >

SYSSYNONYMS

The syssynonyms system catalog table lists the synonyms for each table or view. Except for database servers that have migrated from certain interim releases of Version 1.10 Informix database servers, only the syssyntable table describes synonyms, and the syssynonyms table is unused. It 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.

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]