Object documentationTABLES Locate this document in the navigation structure

 

The system table DOMAIN.TABLES contains information from all the tables (base tables, view tables, synonyms and results tables) for which the current user has privileges.

Structure

TABLES

SCHEMANAME

CHAR(32)

Name of the schema of the table

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)

Type of table (SYNONYM | SYSTEM | TABLE)

TABLETYPE

CHAR(8)

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

CREATEDATE

DATE

Creation date of the table

CREATETIME

TIME

Creation time of the table

UPDSTATDATE

DATE

Date of the last UPDATE STATISTICS statement executed for the table

UPDSTATTIME

TIME

Time of the last UPDATE STATISTICS statement executed for the table

ALTERDATE

DATE

Change date of the table

ALTERTIME

TIME

Change time of the table

UNLOADED

CHAR(3)

Table is unloaded (YES | NO)

SAMPLE_PERCENT

FIXED(3)

Percentage of table contents to be read for updating statistics

SAMPLE_ROWS

FIXED(10)

Number of rows in table to be read for updating statistics

COMMENT

CLOB

Comment on the table

TABLEID

CHAR(8) BYTE

Identification of the table in hexadecimal notation

DYNAMIC

CHAR(3)

Table was defined with DYNAMIC option (YES | NO)

ARCHIVE

CHAR(3)

Table was defined with FOR ARCHIVE option (YES | NO)

VARIABLE_COLUMNS

CHAR(3)

Columns are stored with variable length (YES | NO)

VIRTUALKEY

CHAR(3)

Table was defined with the CLUSTER option (YES | NO)

CLUSTERCOSTSAVINGPERCENTAGE

FIXED(3)

Percentage of I/O savings because of CLUSTER option

DATASOURCEID

CHAR(8)

datasource identification for the external table

If the TABLES system table is called by the database system administrator, information from all database users’ tables is displayed.

More Information

Evaluating System Tables, TABLES

SQL Reference Manual, Table Name (table_name)