Hiding System Objects in Object Explorer in SQL Server Management Studio

By:   |   Updated: 2011-02-25   |   Comments (1)   |   Related: 1 | 2 | > SQL Server Management Studio Configuration


Please do not scroll away - stay informed.
Dear Database Professional,

Did you know that MSSQLTips.com publishes new SQL Server content on a daily basis as well as offers free webinars and tutorials?

Let us help you stay informed and learn something new each day. Click here to keep informed.

Thank you,
Greg Robidoux and Jeremy Kadlec (MSSQLTips.com Co-Founders)
Problem

While looking through the new features and improvements in SQL Server Management Studio (SSMS) we found a potentially interesting one to Hide System Objects in Object Explorer in SQL Server Management Studio. In this tip we will take a look at how to Hide System Objects in Object Explorer.

Solution

You may have noticed that once you are connected to a SQL Server Instance using SQL Server Management Studio, in the Databases node of Object Explorer you can see system objects such as the system databases as shown in the snippet below.

how to hide system objects in object explorer in ssms

You can hide system objects in Object Explorer by following the below mentioned steps:

1. In SQL Server Management Studio, under Tools menu, click Options as shown in the snippet below.

go to tools in ssms

2. In the Options dialog box, expand Environment and then select the General tab as shown in the snippet below. Select Hide system objects in Object Explorer and then click OK.

select the genral tab in ssms

3. In the Microsoft SQL Server Management Studio dialog box, click OK to acknowledge that the changes will come into effect once you restart SQL Server Management Studio.

you must restart sql server management studio

4. Next, go ahead and close SQL Server Management Studio. When you reopen SQL Server Management Studio once you are connected to SQL Server Instance you will not see the System Objects in Object Explorer in SQL Server Management Studio as shown in the snippet below.

when you reopen ssms  once you are connected to sql server instance it will look like the snippet below

Next Steps





get scripts

next tip button



About the author
MSSQLTips author Ashish Kumar Mehta Ashish Kumar Mehta has been contributing to the MSSQLTips.com community since 2009 with over 60 tips.

View all my tips


Article Last Updated: 2011-02-25

Comments For This Article




Thursday, March 3, 2011 - 5:01:11 PM - Tim Back To Top (13116)

Thanks for the tips.  Since I rarely use the system database I'm think I'm going to go ahead and hide them.















get free sql tips
agree to terms