| title | Tool Windows in SQL Server Management Studio | ||
|---|---|---|---|
| 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 |
|
||
| ms.assetid | d3be5062-234c-43a8-8d47-cce111dd3c25 | ||
| author | markingmyname | ||
| ms.author | maghan |
[!INCLUDEappliesto-ss-asdb-asdw-pdw-md] [!INCLUDEssManStudioFull] 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 [!INCLUDEssManStudioFull] 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.