Rediger

Del via


Open and configure Object Explorer

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

Object Explorer is the primary tool window in SQL Server Management Studio (SSMS) for browsing servers and databases. From Object Explorer you can create and locate objects, manage data sources, and view logs.

View Object Explorer

The Object Explorer tool window is available when you connect to a SQL database. If you don't see Object Explorer, select View > Object Explorer, or select F8.

Configure Object Explorer options

By default, Object Explorer opens when you start SSMS. You can change this behavior in Tools > Options > Environment > Startup.

To configure Object Explorer settings, including scripting behavior, go to Tools > Options > SQL Server Object Explorer.

Within Object Explorer, objects are grouped by type (table, stored procedure) by default. Starting with SSMS 22.4.1, objects can be grouped by schema for any SQL database. Use the group by schema icon to toggle the setting, and you can change the default behavior in Tools > Options > SQL Server Object Explorer > General > Group objects by Schema.