Skip to content

hide-system-objects-in-object-explorer.md

Latest commit

 

History

History
35 lines (28 loc) · 1.66 KB

hide-system-objects-in-object-explorer.md

File metadata and controls

35 lines (28 loc) · 1.66 KB
description Hide System Objects in Object Explorer
title Hide System Objects in Object Explorer
ms.custom seo-lt-2019
ms.date 01/19/2017
ms.prod sql
ms.prod_service sql-tools
ms.reviewer
ms.technology ssms
ms.topic conceptual
helpviewer_keywords
hiding system objects
system objects [SQL Server]
objects [SQL Server], hiding
Object Explorer, hiding objects
ms.assetid c01d8804-838c-4f75-b78c-80e41e4fffdc
author markingmyname
ms.author maghan

Hide System Objects in Object Explorer

[!INCLUDESQL Server Azure SQL Database Synapse Analytics PDW] This topic describes how to hide system objects in Object Explorer in [!INCLUDEssnoversion] by using [!INCLUDEssManStudioFull]. 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.

Using SQL Server Management Studio

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.