Returns information about the index key. Returns NULL for XML indexes.
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Instead, use sys.index_columns (Transact-SQL).
Returns NULL on error or if a caller does not have permission to view the object.
A user can only view the metadata of securables that the user owns or on which the user has been granted permission. This means that metadata-emitting, built-in functions such as INDEXKEY_PROPERTY may return NULL if the user does not have any permission on the object. For more information, see Metadata Visibility Configuration and Troubleshooting Metadata Visibility.
In the following example, both properties are returned for index ID 1, key column 1 in the Production.Location table.
Here is the result set:
Column ID Asc or Desc order ----------- ----------------- 1 0 (1 row(s) affected)