OWNER

CHAR(32)

Name of the owner of the table

TABLENAME

CHAR(32)

Name of the table

PRIVILEGES

CHAR(30)

Privileges of the current user for the table

TYPE

CHAR(8)

Table type (SYSTEMS | TABLES)

TABLETYPE

CHAR(8)

Type of table (TABLE | VIEW | SYNONYM | RESULT)

CREATEDATE

DATE(10)

Creation date of the table

CREATETIME

TIME(8)

Creation time of the table

UPDSTATDATE

DATE(10)

Date at which the UPDATE STATISTICS statement was last carried out on the table

UPDSTATTIME

TIME(8)

Time at which the UPDATE STATISTICS statement was last carried out on the table

ALTERDATE

DATE(10)

Change date of the table

ALTERTIME

TIME(8)

Change time of the table

UNLOADED

CHAR(3)

Table is unloaded (YES | NO)

SAMPLE_PERCENT

FIXED(3)

Percentage share of the table to be used to update statistics

SAMPLE_ROWS

FIXED(10)

Number of rows in the table to be used to update statistics

COMMENT

LONG

Comment on the table

TABLEID

CHAR(8) BYTE

Table identification in hexadecimal notation