Export (0) Print
Expand All
ABS
ALL
AND
ANY
AVG
bit
COS
COT
DAY
EXP
GO
IN
LEN
LOG
MAX
MIN
NOT
OR
PI
SET
SIN
STR
SUM
TAN
USE
VAR
Expand Minimize

INDEXKEY_PROPERTY

SQL Server 2000

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')
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft