The SQLSCHEMAS view contains one row for every schema. The following
table describes the columns in the 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. |
(C) Copyright IBM Corporation 1992, 2005. All Rights Reserved.