• quote:


    Information Schema Views were introduced in Microsoft SQL Server 2000


    No, no, no, INFORMATION_SCHEMA views are hidden in SQL 2000, but were clearly browsable with Enterprise Manager back in SQL 7. INFORMATION_SCHEMA is supposed to be some sort of a standard for accessing database schema. Now it is pretty hard getting the names of INFORMATION_SCHEMA views. And if you look at their sources you can find some strange ways Microsoft uses system tables. Looking at view sources you can clearly see things that are not implemented or implemented differently in SQL Server.