sysindexkeys System Table - SQL Server 2000

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

Column nameData typeDescription
idintID of the table
indidsmallintID of the index
colidsmallintID of the column
keynosmallintPosition of the column in the index