SQL Server provides a number of views for accessing the system catalogs. These objects provide an ANSI SQL-92 compliant means of retrieving meta- data and system-level information from the server. You should use these rather than querying system catalog tables for two reasons:
You can depend on them not to change across releases of SQL Server, even though their underlying system tables may change.
The ANSI SQL-92 specification defines these views, so they should work similarly between different DBMS platforms.
The SQL-92-compliant views that SQL Server provides are as follows: