| title | ms.date | ms.prod | ms.technology | ms.reviewer | ms.topic | f1_keywords | helpviewer_keywords | ms.assetid | author | ms.author | manager | ||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
SQL Server Management Studio (SSMS) | Microsoft Docs |
10/16/2018 |
sql |
ssms |
conceptual |
|
|
66a6b7b1-de6a-4161-82bd-98ded486947b |
markingmyname |
maghan |
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]