SQL Server Management Studio (SSMS)SQL Server Management Studio (SSMS)

适用对象:yesSQL ServeryesAzure SQL 数据库yesAzure SQL 数据仓库yes并行数据仓库APPLIES TO: yesSQL Server yesAzure SQL Database yesAzure SQL Data Warehouse yesParallel Data Warehouse

SQL Server Management StudioSQL Server Management Studio (SSMS) 是用于管理任何 SQL 基础结构的集成环境。(SSMS) is an integrated environment for managing any SQL infrastructure. 使用 SSMS,可以访问、配置、管理和开发 SQL ServerSQL Server、Azure SQL 数据库和 SQL 数据仓库的所有组件。Use SSMS to access, configure, manage, administer, and develop all components of SQL ServerSQL Server, Azure SQL Database, and SQL Data Warehouse. SSMS 在一个综合实用工具中汇集了大量图形工具和丰富的脚本编辑器,为各种技能水平的开发者和数据库管理员提供对 SQL ServerSQL Server 的访问权限。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 SQL ServerSQL Server for developers and database administrators of all skill levels.

SQL Server Management Studio 组件SQL Server Management Studio components

描述Description 组件Component
使用“对象资源管理器”查看和管理 SQL ServerSQL Server 的一个或多个实例中的所有对象。Use Object Explorer to view and manage all of the objects in one or more instances of SQL ServerSQL Server. 对象资源管理器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
如何使用 Management StudioManagement Studio中包含的可视化设计工具。How to use the visual design tools included in Management StudioManagement Studio. Visual Database ToolsVisual Database Tools
如何使用 Management StudioManagement Studio 语言编辑器交互式生成和调试查询和脚本。How to use the Management StudioManagement Studio language editors to interactively build and debug queries and scripts. 查询和文本编辑器 (SQL Server Management Studio)Query and Text Editors (SQL Server Management Studio)

SSMS 的支持策略Support Policy for SSMS

后续步骤Next steps

教程:SQL Server Management StudioTutorial: SQL Server Management Studio
教程:编写 Transact-SQL 语句Tutorial: Writing Transact-SQL Statements

编辑内容 参与编辑 SQL 文档Contribute SQL documentation

您是否知道,您可以编辑内容自己?Did you know that you could edit the content yourself? 如果这样做,不仅将得到改善我们的文档,而且你将还贷记作为参与者到页。If you do so, not only will our documentation improve, but you'll also be credited as a contributor to the page.

info_tip 获取帮助Get Help