The query corresponding to the monitoring element to check the constraints information is as follows.
This shows a list of all constraints created in the database.
The query below works in Altibase 6.3.1 or later and can be used in lower versions by deleting the comment section.
| Column | Description |
|---|---|
| OBJECT_TYPE | The type of object. TABLE (T), VIEW (V), SEQUENCE (S), QUEUE (Q) |
| CONST_TYPE | The type of Constraint FOREIGN KEY (0), NOT NULL (1), UNIQUE (2), PRIMARY KEY (3), NULL (4), TIMESTAMP (5), LOCAL UNIQUE (6), CHECK (7) |
| CHECK_CONDITION | This shows integrity rules defined when specifying CHECK constraints. This column is supported in Altibase 6.3.1 or later. |
This shows information about the primary key, foreign key, and unique constraints.
| Column | Description |
|---|---|
| P_TABLE | If the constraint is Foreign Key, the name of the referenced table. |
| R_INDEX | If the constraint is Foreign Key, the name of the referenced index. |
This shows the composite index configuration information.
| Column | Description |
|---|---|
| COL_ORDER | The order in which index columns are organized. Start at 0. |
| SORT | Sort type of index column ASC (A), DESC (D) |
This shows all the index information.
| Column | Description |
|---|---|
| TBS_NAME | The name of the tablespace where the index is stored. (For compatibility with A4, indexes without a tablespace are considered memory tablespaces.) |
| IS_UNIQUE | Whether the index is unique. TRUE (T), FALSE (F) |
| COLUMN_CNT | The number of columns that make up the index |