HSSYSSYN

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