Transact-SQL Reference

sysindexkeys

Contains information for the keys or columns in an index. This table is stored in each database.

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