The SQLTABLES view contains one row for every table, view, and alias. 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 containing the table. |
TABLE_NAME | VARCHAR(128) | Name of the table. |
TABLE_TYPE | VARCHAR(24) | Indicates the type of the table:
|
REMARKS | VARCHAR(2000)
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 | VARCHAR(50) | A character string provided with the LABEL statement. |
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.