| title | Tool Windows in SQL Server Management Studio | ||
|---|---|---|---|
| description | Tool Windows in SQL Server Management Studio | ||
| ms.prod | sql | ||
| ms.prod_service | sql-tools | ||
| ms.technology | ssms | ||
| ms.topic | ui-reference | ||
| helpviewer_keywords |
|
||
| author | markingmyname | ||
| ms.author | maghan | ||
| ms.reviewer | |||
| ms.custom | seo-lt-2019 | ||
| ms.date | 01/19/2017 |
[!INCLUDESQL Server Azure SQL Database Synapse Analytics PDW]
SQL Server Management Studio provides many powerful tool windows for all phases of development and administration. Some tools can be used on any [!INCLUDEssNoVersion] component, and others are for certain components only. The following table identifies the tools that can be used for all components of [!INCLUDEssNoVersion].
| Tool | Purpose |
|---|---|
| Object Explorer | Browse servers, create and locate objects, manage data sources, and view logs. This tool is accessed from the View menu. |
| Solution Explorer | Store and organize scripts and related connection information in projects called [!INCLUDEssNoVersion] Scripts. You can store several [!INCLUDEssNoVersion] Scripts as Solutions and use source control to manage scripts as they evolve over time. This tool is accessed from the View menu. |
| Template Explorer | Create queries based on existing templates. You can also create your custom queries or alter the existing templates to fit your scenarios. This tool is accessed from the View menu. |
| Dynamic Help | Show a list of related Help topics as you click on a component or type code. |
The tools in SQL Server Management Studio work together.
For example, you can:
-
Register a server with Object Explorer.
-
Open a SQL Editor window connected to a specific database from Object Explorer.