Skip to content

Latest commit

 

History

History
46 lines (41 loc) · 3.02 KB

File metadata and controls

46 lines (41 loc) · 3.02 KB
title Object Explorer | Microsoft Docs
ms.custom
ms.date 06/13/2017
ms.prod sql-server-2014
ms.reviewer
ms.technology ssms
ms.topic conceptual
f1_keywords
sql12.swb.objectexplorer.commandsoptions
SQL12.SWB.SQLSERVEROBJECTEXPLORER.DHELP
sql12.swb.objectexplorer.scriptingoptions
sql12.swb.oe.f1
helpviewer_keywords
multi-select [SQL Server Management Studio]
Registered Servers [SQL Server], Object Explorer
Query Editor [SQL Server Management Studio], Object Explorer
connections [SQL Server], SQL Server Management Studio
servers [SQL Server], Registered Servers
Object Explorer
SQL Server Management Studio [SQL Server], connections
viewing objects
filtering objects [SQL Server]
Object Explorer, about Object Explorer
ms.assetid 469ea8e2-79b9-44c8-bb6f-f0e1c5dbf0f2
author stevestein
ms.author sstein
manager craigg

Object Explorer

[!INCLUDEssManStudioFull] provides features for managing objects in instances of the [!INCLUDEssDE], [!INCLUDEssASnoversion], [!INCLUDEssISnoversion], and [!INCLUDEssRSnoversion].

Benefits of Object Explorer

Object Explorer provides a hierarchical user interface to view and manage the objects in each instance of SQL Server. The Object Explorer Details pane presents a tabular view of instance objects, and the capability to search for specific objects. The capabilities of Object Explorer vary slightly depending on the type of server, but generally include the development features for databases, and management features for all server types.

Object Explorer Tasks

Description Topic
Describes how to open the Object Explorer and configure the options that define the behavior of the explorer. Open and Configure Object Explorer
Describes how to connect Object Explorer to an instance of the [!INCLUDEssDE], [!INCLUDEssASnoversion], [!INCLUDEssRSnoversion], and [!INCLUDEssISnoversion]. Connect to an Instance From Object Explorer
Describes how to manage objects represented as nodes in the Object Explorer hierarchy. Manage Objects by Using Object Explorer
Describes the Object Explorer Details Pane, a tabular view of all of the objects in the server with a user interface to manage them. Object Explorer Details Pane
Describes ways to run custom reports in [!INCLUDEssManStudioFull]. Custom Reports in Management Studio