DB2 Universal Database for iSeries SQL Reference

TABLES

The TABLES view contains one row for each table, view, and alias. The following table describes the columns in the view:

Table 161. TABLES view

Column Name Data Type Description
TABLE_CATALOG VARCHAR(128) Relational database name
TABLE_SCHEMA VARCHAR(128) Name of the SQL schema that contains the table, view or alias.
TABLE_NAME VARCHAR(128) Name of the table, view or alias.
TABLE_TYPE VARCHAR(24) Indicates the type of the table:

ALIAS
The table is an alias.

BASE TABLE
The table is an SQL table or physical file.

MATERIALIZED QUERY TABLE
The object is a materialized query table.

VIEW
The table is an SQL view or logical file.
SELF_REFERENCING_COLUMN_NAME VARCHAR(128)
Nullable
Reserved. Contains the null value.
REFERENCE_GENERATION VARCHAR(128)
Nullable
Reserved. Contains the null value.
USER_DEFINED_TYPE_CATALOG VARCHAR(128)
Nullable
Reserved. Contains the null value.
USER_DEFINED_TYPE_SCHEMA VARCHAR(128)
Nullable
Reserved. Contains the null value.
USER_DEFINED_TYPE_NAME VARCHAR(128)
Nullable
Reserved. Contains the null value.
IS_INSERTABLE_INTO VARCHAR(3) Identifies whether an INSERT is allowed on the table.

NO
An INSERT is not allowed on this table.

YES
An INSERT is allowed on this table.


[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]