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)
Nullable |
Reserved. Contains the null value. |
REMARKS | VARCHAR(2000)
Nullable |
Reserved. Contains the null value. |
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. |
SCHEMA_TEXT | VARCHAR(50)
Nullable |
A character string that describes the schema.
Contains the empty string if there is no text. |
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.