Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  using keycnt in sysindexes table

Author  Topic  spock Starting Member 35 Posts Posted - 2002-02-05 : 09:38:47 Hi Using the sysindexes table i am trying to find out the columns and number of columns involved in each index for a given table.i tried reading the keycnt column but it returns erroneous numbers. according to bol, quote: keycnt smallint Number of keys. if it does not return the number of rows involved in the index what info does it hold? thanks kaushik