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 | VARGRAPHIC(2000) CCSID
1200Nullable ![]() |
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 | VARGRAPHIC(50) CCSID
1200![]() |
A character string provided with the LABEL statement. |