The HSSYSYN table is used for SYSSYNONYMS views. The following table describes the columns in the HSSYSSYN table:
| Column | Type | Length | Decimal | Domain |
|---|---|---|---|---|
| NAME | VARCHAR | 128 | 0 | Synonym for the table or view |
| CREATOR | VARCHAR | 128 | 0 | Authorization ID of the owner of the synonym |
| TBNAME | VARCHAR | 128 | 0 | Name of the table or view |
| TBCREATOR | VARCHAR | 128 | 0 | The schema of the table or view |
| IBMREQD | CHAR | 1 | 0 | |
| CREATEDBY | VARCHAR | 128 | 0 | Primary authorization ID of the user who created the synonym |
| CREATEDTS | TIMESTAMP | 26 | 0 | Time when the CREATE statement was executed for the synonym |