Purpose
The oceanbase.CDB_IND_COLUMNS view displays the column information of the index tables of all tenants.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| CON_ID | decimal(10,0) | NO | The ID of the tenant. |
| INDEX_OWNER | varchar(128) | NO | The owner of the index. |
| INDEX_NAME | varchar(128) | NO | The name of the index. |
| TABLE_OWNER | varchar(128) | NO | The owner of the table containing the index. |
| TABLE_NAME | varchar(128) | NO | The name of the table containing the index. |
| COLUMN_NAME | varchar(4000) | NO | The name of the indexed column. |
| COLUMN_POSITION | bigint(20) | NO | The position of the indexed column in the index. |
| COLUMN_LENGTH | bigint(20) | NO | The length of the indexed column. |
| CHAR_LENGTH | bigint(20) | NO | The character length of the indexed column. |
| DESCEND | varchar(4) | NO | Indicates whether the column is sorted in descending order or ascending order. |
| COLLATED_COLUMN_ID | bigint(0) | NO | At present, this column is not supported and is NULL by default. |
