DB2 Universal Database for iSeries SQL Reference

SQLSCHEMAS

The SQLSCHEMAS view contains one row for every schema. The following table describes the columns in the view:

Table 142. SQLSCHEMAS view

Column Name Data Type Description
TABLE_CAT VARCHAR(128) Relational database name
TABLE_SCHEM VARCHAR(128) Name of the schema.
TABLE_NAME VARCHAR(128)
Nullable
Reserved. Contains the null value.
TABLE_TYPE VARCHAR(128) Reserved. Contains the null value.
Nullable
REMARKS VARCHAR(2000) Reserved. Contains the null value.
Nullable
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) Reserved. Contains the null value.
Nullable
SCHEMA_TEXT VARCHAR(50) A character string that describes the schema.

Contains the empty string if there is no text.


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