SYSSYNONYMS catalog table
The SYSSYNONYMS table contains one row for each synonym of a table or view. The schema is SYSIBM.
| Column name | Data type | Description | Use |
|---|---|---|---|
| NAME | VARCHAR(128)
NOT NULL |
Synonym for the table or view. | G |
| CREATOR | VARCHAR(128)
NOT NULL |
Authorization ID of the owner of the synonym. | G |
| TBNAME | VARCHAR(128)
NOT NULL |
Name of the table or view. | G |
| TBCREATOR | VARCHAR(128)
NOT NULL |
The schema of the table or view. |
G |
| IBMREQD | CHAR(1)
NOT NULL |
A value of Y indicates that the row was provided with the Db2 product code. For all other values, see Release dependency indicators. The value in this field is not a reliable indicator of release dependencies. RELCREATED should be used instead. |
G |
| CREATEDBY | VARCHAR(128)
NOT NULL WITH DEFAULT |
Primary authorization ID of the user who created the synonym. | G |
| CREATEDTS | TIMESTAMP
NOT NULL WITH DEFAULT |
Time when the CREATE statement was executed for the synonym. The value is '0001-01.01.00.00.00.000000' for synonyms created in a Db2 release prior to Version 5. | G |
| CREATORTYPE | CHAR(1)
NOT NULL WITH DEFAULT |
Indicates the type of creator:
|
G |
| RELCREATED | CHAR(1)
NOT NULL |
The release of Db2 that is used to create the object. Blank if created prior to Version 9. See Release dependency indicators for all other values. | G |