I'm assuming you're using SQL Server 2000? In
SQL Server Books Online (SQL Server's help file), you can find information on
two types of system catalogs in SQL Server:
A) Look up the INFORMATION_SCHEMA views.
These views make up the ANSI-standard system catalog, and contain
information about most of the user metadata ese(tables/columns/etc)
B) All of the tables prefixed with 'sys' are SQL
Server's proprietary system catalog. Try to avoid writing code against
these, as they are deprecated in SQL Server 2005.
If you're using SQL Server 2005 already, look at
the views in the 'sys' schema.
Hi
I am new to database design and SQL server and am looking for some information
on the systems catalogue.
Can anyone tell me where I would find
a list of the type of information held in the systems catalogue and if this
information is held in the format of a database itself does SQL Server have
specific/recommended names for the tables??
Thanks in
advance.
System Catalogue
