HSURDSYT

The HSURDSYT table is used for SYSTABLES views. The following table describes the columns in the HSURDSYT table:

Column Type Length Decimal Domain
NAME VARCHAR 128 0 Name of the table
CREATOR VARCHAR 128 0 Owner of the table
TYPE CHAR 1 0 Type of object
COLCOUNT SMALLINT 4 0 Number of columns
RECLENGTH SMALLINT 4 0 Record length
LABEL CHAR 30 0 Label of the table
CREATEDTS TIMESTAMP 26 0 Time creation table
ALTEREDTS TIMESTAMP 26 0 Time last alteration
TSNAME CHAR 24 0 Table space name
DBNAME CHAR 24 0 Data base name
OBID SMALLINT 4 0 OBID