| title | SQL Server Management Studio (SSMS) | Microsoft Docs | |
|---|---|---|
| ms.date | 10/16/2018 | |
| ms.prod | sql | |
| ms.technology | ssms | |
| ms.reviewer | ||
| ms.topic | conceptual | |
| f1_keywords |
|
|
| helpviewer_keywords |
|
|
| ms.assetid | 66a6b7b1-de6a-4161-82bd-98ded486947b | |
| author | stevestein | |
| ms.author | sstein | |
| manager | craigg |
[!INCLUDEappliesto-ss-asdb-asdw-pdw-md]
[!INCLUDEssManStudioFull] (SSMS) is an integrated environment for managing any SQL infrastructure. Use SSMS to access, configure, manage, administer, and develop all components of [!INCLUDEssNoVersion], Azure SQL Database, and SQL Data Warehouse. SSMS provides a single comprehensive utility that combines a broad group of graphical tools with a number of rich script editors to provide access to [!INCLUDEssNoVersion] for developers and database administrators of all skill levels.
- Download SQL Server Management Studio (SSMS)
- Download SQL Server 2016 Developer
- Download Visual Studio
| Description | Component |
|---|---|
| Use Object Explorer to view and manage all of the objects in one or more instances of [!INCLUDEssNoVersion]. | Object Explorer |
| How to use Template Explorer to build and manage files of boilerplate text that can be used to speed the development of queries and scripts. | Template Explorer |
| How to use the deprecated Solution Explorer to build projects used to manage administration items such as scripts and queries. | Solution Explorer |
| How to use the visual design tools included in [!INCLUDEssManStudio]. | Visual Database Tools |
| How to use the [!INCLUDEssManStudio] language editors to interactively build and debug queries and scripts. | Query and Text Editors (SQL Server Management Studio) |
- Starting with SSMS 17.0, the SQL Tools team has adopted the Microsoft Modern Lifecycle Policy.
- Read the original Modern Lifecycle Policy announcement.
- For additional infomrmation, see Modern Policy FAQs.
Tutorial: SQL Server Management Studio
Tutorial: Writing Transact-SQL Statements
[!INCLUDEcontribute-to-content]
[!INCLUDEget-help-options]