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.
|