Export (0) Print
Expand All

Hide System Objects in Object Explorer

This topic describes how to hide system objects in Object Explorer in SQL Server 2014 by using SQL Server Management Studio. The Databases node of Object Explorer contains system objects such as the system databases. Use the Tools/Options pages to hide the system objects. Some system objects, such as system functions and system data types, are not affected by this setting.

To hide system objects in Object Explorer

  1. On the Tools menu, click Options.

  2. On the Environment/Startup page, select Hide system objects in Object Explorer, and then click OK.

  3. In the SQL Server Management Studio dialog box, click OK to acknowledge that SQL Server Management Studio must be restarted for this change to take effect.

  4. Close and reopen SQL Server Management Studio.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft