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 | VARCHAR | 90 | 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 |