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 VARGRAPHIC(2000) CCSID 1200
Nullable
 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 VARGRAPHIC(50) CCSID 1200 A character string provided with the LABEL statement.