Zack Sessions (zc********@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,
so****@algonet.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp