Returns information about the index key.
Syntax
INDEXKEY_PROPERTY ( table_ID , index_ID , key_ID , property )
Arguments
table_ID
Is the table identification number. table_ID is int.
index_ID
Is the index identification number. index_ID is int.
key_ID
Is the index column position. key_ID is int.
property
Is the name of the property for which information will be returned. property is a character string and can be one of these values.
| Value | Description |
| ColumnId | Column ID at the key_ID position of the index. |
| IsDescending | Order in which the index column is stored.
1 = Descending
0 = Ascending |
Return Types
int
Examples
SELECT indexkey_property(OBJECT_ID('authors'),2,2,'ColumnId')
SELECT indexkey_property(OBJECT_ID('authors'),2,2,'IsDescending')
