Purpose
The oceanbase.CDB_IND_COLUMNS view provides the column information about the index tables of all tenants.
Note
This view is introduced since OceanBase Database V4.0.0.
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 | text | 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. |