| title | ms.custom | ms.date | ms.prod | ms.prod_service | ms.reviewer | ms.technology | ms.topic | helpviewer_keywords | ms.assetid | author | ms.author | manager | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Tool Windows in SQL Server Management Studio | Microsoft Docs |
01/19/2017 |
sql |
sql-tools |
ssms |
conceptual |
|
d3be5062-234c-43a8-8d47-cce111dd3c25 |
markingmyname |
maghan |
craigg |
[!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.