INDEX_COLUMNS view¶
This Account Usage schema view displays a row for each column in the indexes defined in the specified (or current) database.
Columns¶
Column Name |
Data Type |
Description |
---|---|---|
ID |
NUMBER |
ID of the column. |
NAME |
TEXT |
Name of the column. |
INDEX_ID |
NUMBER |
ID of the index. |
INDEX_NAME |
TEXT |
Name of the index. |
TABLE_ID |
NUMBER |
ID of the hybrid table. |
TABLE_NAME |
TEXT |
Name of the hybrid table. |
SCHEMA_ID |
TEXT |
ID of the schema to which the hybrid table belongs. |
SCHEMA_NAME |
TEXT |
Schema to which the hybrid table belongs. |
DATABASE_ID |
NUMBER |
ID of the database to which the hybrid table belongs. |
DATABASE_NAME |
TEXT |
Database to which the hybrid table belongs. |
KEY_SEQUENCE |
NUMBER |
Position of the column in the index. |
INDEX_OWNER |
TEXT |
Owner of the index. |
IS_UNIQUE |
TEXT |
With |
IS_INCLUDED_COLUMN |
TEXT |
With |
CONSTRAINT_NAME |
TEXT |
Name of the constraint that is associated with this index. |
STATUS |
TEXT |
Status of this index. |
CREATED |
TIMESTAMP_LTZ |
Time of creation for this index. |
DELETED |
TIMESTAMP_LTZ |
Date and time when the hybrid table was dropped. |
OWNER_ROLE_TYPE |
TEXT |
The type of role that owns the object, for example |
Usage notes¶
Latency for the view may be up to 180 minutes (3 hours).