Note

Access to this page requires authorization. You can try signing in or .

Access to this page requires authorization. You can try .

Object Explorer

Applies to: 👁 Image
SQL Server 👁 Image
Azure SQL Database 👁 Image
Azure SQL Managed Instance 👁 Image
Azure Synapse Analytics 👁 Image
Analytics Platform System (PDW) 👁 Image
SQL analytics endpoint in Microsoft Fabric 👁 Image
Warehouse in Microsoft Fabric 👁 Image
SQL database in Microsoft Fabric

SQL Server Management Studio provides features for managing objects in instances of the Database Engine, Analysis Services, Integration Services, and Reporting Services.

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 Article
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 to a database. Connect with SQL Server Management Studio
Describes how to manage objects represented as nodes in the Object Explorer hierarchy. Manage objects 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 SQL Server Management Studio. Custom reports in SQL Server Management Studio

Feedback

Was this page helpful?

Additional resources