Indexes Schema
The Indexes schema provides information about indexes in the server’s SQL syntax.
| Column Name | Data Type | Description |
|---|---|---|
| INDEX_CATALOG | string | |
| INDEX_SCHEMA | string | |
| INDEX_NAME | string | |
| TABLE_NAME | string | |
| UNIQUE | bool | |
| PRIMARY | bool | |
| TYPE | string | |
| COMMENT | string |
The following restrictions are supported:
| Restriction Name | Restriction Default | Restriction Number |
|---|---|---|
| Catalog | TABLE_CATALOG | 1 |
| Schema | TABLE_SCHEMA | 2 |
| Table | TABLE_NAME | 3 |
| Name | INDEX_NAME | 4 |