Listing all Indexes

Still using SQL7.

I am wondering how come there is not an Information_Schema view that
lists indexes? Information_Schema is supposed to be the safest way to
obtain information on metadata, but it appears that the only way to
get a list of indexes is with a system stored proc.Zack Sessions (zcsessions@.visionair.com) writes:
> Still using SQL7.
> I am wondering how come there is not an Information_Schema view that
> lists indexes? Information_Schema is supposed to be the safest way to
> obtain information on metadata, but it appears that the only way to
> get a list of indexes is with a system stored proc.

I guess this is because INFORMATION_SCHEMA comes from ANSI, and ANSI
does not know what an index is, as index is regarded to be an implementation
issue. And someone leaped to the conclusion that INFORMATION_SCHEMA
could replace system tables.

One of the reasons I prefer the system tables (together with property
functions) is that they represent complete information set.

--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp