The TABLES view contains one row for each table, view, and alias. The following table describes the columns in the view:
Column Name | Data Type | Description |
---|---|---|
TABLE_CATALOG | VARCHAR(128) | Relational database name |
TABLE_SCHEMA | VARCHAR(128) | Name of the SQL schema that contains the table, view or alias. |
TABLE_NAME | VARCHAR(128) | Name of the table, view or alias. |
TABLE_TYPE | VARCHAR(24) | Indicates the type of the table:
|
SELF_REFERENCING_COLUMN_NAME | VARCHAR(128)
Nullable |
Reserved. Contains the null value. |
REFERENCE_GENERATION | VARCHAR(128)
Nullable |
Reserved. Contains the null value. |
USER_DEFINED_TYPE_CATALOG | VARCHAR(128)
Nullable |
Reserved. Contains the null value. |
USER_DEFINED_TYPE_SCHEMA | VARCHAR(128)
Nullable |
Reserved. Contains the null value. |
USER_DEFINED_TYPE_NAME | VARCHAR(128)
Nullable |
Reserved. Contains the null value. |
IS_INSERTABLE_INTO | VARCHAR(3) | Identifies whether an INSERT is allowed on
the table.
|
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.