March 2006
Beginner to intermediate
336 pages
7h 49m
English
Content preview from SQL Server 2005 DistilledBecome an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
Appendix B. System Tables and View in SQL Server 2005
SQL Server 2000 used system tables to store meta-data about everything happening in the database. SQL Server 2005 doesn’t use system tables. The following table maps the new Views to the SQL Server 2000 system tables. You can query the views as you would any view, and you will find each database has a catalog of these views specific to that database.
Table B-1. Mapping of System Tables to SQL Server 2005
The following table lists the system tables in every SQL Server 2000 database and their corresponding system view or views in SQL Server 2005.
Table B-2. Mapping of SQL Server 2000 System Tables ...