Home > IT Answers > SQL Server > System tables in SQL Server 2005
SQL Server Ask the Experts
2,585 pts.
 System tables in SQL Server 2005
SQL Server 2005, SQL Server System Tables, SQL Server tables, SYSTEM TABLESPACE
What is the role of system tables in SQL Server 2005 and how do you update them?

Software/Hardware used:
ASKED: December 12, 2008  4:20 PM
UPDATED: December 13, 2008  12:23 AM
RELATED QUESTIONS
Answer Wiki:
In SQL Server 2005 there are no longer any system tables. There are now system catalog views which look into the system catalog to get the information. These catalog views are used to view the metadata about the objects in the database. These views are read only and not be modified. You need to modify the object which you are looking at the data for by using the ALTER TABLE, ALTER PROCEDURE, etc statements.
Last Wiki Answer Submitted:  December 13, 2008  12:23 am  by  Denny Cherry   64,520 pts.
All Answer Wiki Contributors:  Denny Cherry   64,520 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _