Information schema views provide an internal, system table-independent view of the SQL Server metadata.
However, information schema views are compliant with protocols laid out by the International Organization for Standardization, or ISO.
The information views are part of the SQL-92 standard, so they are not likely to change.
There are 20 schema views in all, listed below with their purpose (aggregated from SQL Books).
Note that in all cases, only data accessible to the user executing the query against the information_schema views is returned. Please note that the information schema views are based on a SQL-92 standard so some of the terms used in these views are different than the terms in Microsoft SQL Server.
For example, in the example above, I set I generally don’t go to all this trouble for stored procedures, user defined functions, and views.