Saturday, October 04, 2008

sysindexkeys (T-SQL)

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

No comments: