Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How do I hide system tables in SQL Servers Enterprise Manager?

April 26, 2017Enterprise Hide manager server sql system tables

0

Posted

How do I hide system tables in SQL Servers Enterprise Manager?

1 Answer

0

Posted

Many people don’t like the clutter provided so graciously by the existence of all the system tables, objects and stored procedures in SQL Server’s user interface. To get rid of the system objects, just right-click the server in question (in MMC), choose “Edit SQL Server Registration properties…”, and uncheck “Show system databases and system objects” … hit OK and that clutter should disappear, making direct manipulation of your data much easier. This will work in both SQL Server 7.0 and SQL Server 2000. In SQL Server 2005’s new tool called Management Studio, go to Tools / Options / Environment / General and choose “Hide system objects in Object Explorer.” Unlike Enterprise Manager, where this setting takes effect immediately, you will need to restart Management Studio to get rid of the clutter.