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

適用於: 是SQL Server 是Azure SQL Database 是Azure SQL 資料倉儲 是平行處理資料倉儲 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 Database 和 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 ServerSSMS 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

DescriptionDescription 元件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