SQLTABLES

The SQLTABLES view contains one row for every table, view, and alias.

The following table describes the columns in the view:

Table 1. SQLTABLES view
Column Name Data Type Description
TABLE_CAT VARCHAR(128) Relational database name
TABLE_SCHEM VARCHAR(128) Name of the schema containing the table.
TABLE_NAME VARCHAR(128) Name of the table.
TABLE_TYPE VARCHAR(24) Indicates the type of the table:
ALIAS
The table is an alias.
MATERIALIZED QUERY TABLE
The object is a materialized query table.
SYSTEM TABLE
The table is a system table.
TABLE
The table is an SQL table or physical file.
VIEW
The table is an SQL view or logical file.
REMARKS Start of changeVARGRAPHIC(2000) CCSID 1200

Nullable

End of change
A character string supplied with the COMMENT statement.

Contains the null value if there is no long comment.

TYPE_CAT VARCHAR(128)

Nullable

Reserved. Contains the null value.
TYPE_SCHEM VARCHAR(128)

Nullable

Reserved. Contains the null value.
TYPE_NAME VARCHAR(128)

Nullable

Reserved. Contains the null value.
SELF_REF_COL_NAME VARCHAR(128)

Nullable

Reserved. Contains the null value.
REF_GENERATION VARCHAR(128)

Nullable

Reserved. Contains the null value.
DBNAME VARCHAR(8)

Nullable

Reserved. Contains the null value.
TABLE_TEXT Start of changeVARGRAPHIC(50) CCSID 1200End of change A character string provided with the LABEL statement.