B.4 Content of SQL_DIV_TABLE
SQL_DIV_TABLE stores information on locations such as DB areas that store base tables, dictionary tables (base tables), and system tables (base tables). Each row stores information for one table.
The following table describes the content of SQL_DIV_TABLE.
|
No. |
Column name |
Data type |
Stored information |
|---|---|---|---|
|
1 |
TABLE_SCHEMA |
VARCHAR(100) |
Schema name |
|
2 |
TABLE_NAME |
VARCHAR(100) |
Table identifier |
|
3 |
TABLE_ID |
SMALLINT |
Table ID:
|
|
4 |
DBAREA_ID |
SMALLINT |
DB area ID of the DB area that stores the table |