sys-sysindexkeys-transact-sql.md

title	sys.sysindexkeys (Transact-SQL)
description	sys.sysindexkeys (Transact-SQL)
author	rwestMSFT
ms.author	randolphwest
ms.date	03/15/2017
ms.service	sql
ms.subservice	system-objects
ms.topic	reference
f1_keywords	sysindexkeys sys.sysindexkeys_TSQL sysindexkeys_TSQL sys.sysindexkeys
helpviewer_keywords	sysindexkeys system table sys.sysindexkeys compatibility view
dev_langs	TSQL

sys.sysindexkeys (Transact-SQL)

[!INCLUDE SQL Server]

Contains information about the keys or columns in an index of the database.

Important

[!INCLUDEssnoteCompView]

Column name	Data type	Description
id	int	ID of the table.
indid	smallint	ID of the index.
colid	smallint	ID of the column.
keyno	smallint	Position of the column in the index.

See Also

Mapping System Tables to System Views (Transact-SQL)
Compatibility Views (Transact-SQL)
sys.index_columns (Transact-SQL)