sql-editor-visual-database-tools.md

title	SQL Editor
ms.custom	seo-lt-2019
ms.date	01/19/2017
ms.prod	sql
ms.prod_service	sql-tools
ms.technology	ssms
ms.topic	conceptual
f1_keywords	vdt.sqleditor sql.data.tools.sqleditor
helpviewer_keywords	SQL Editor modifying triggers modifying functions modifying stored procedures modifying statements Query Designer [SQL Server], SQL Editor View Designer, SQL Editor
ms.assetid	029abf7d-6414-47ca-a3a7-b3a057efb6c2
author	markingmyname
ms.author	maghan
ms.manager	jroth
ms.reviewer

SQL Editor (Visual Database Tools)

[!INCLUDEappliesto-ss-asdb-asdw-pdw-md] Use the SQL Editor to edit existing stored procedures, functions, triggers, and SQL scripts. This window opens when you open any of those objects. If you want to create a new SQL statement to run against your data source, use the SQL Pane of Query Designer.

The SQL editor provides many useful SQL text-editing features, including:

• Color coding of SQL keywords to minimize syntax and spelling errors.

• Generating skeletal stored procedures and triggers.

• Providing useful editing functions, including cut, copy, paste, and dragging operations.

• Changing the editor's behavior (by selecting Options from the Tools menu) to modify virtual spaces, word wrap, line numbers, and tab size.

• Helping manage debugging breakpoints.

Note

The SQL Editor does not have IntelliSense prompting.

When editing SQL statements, certain Transact-SQL statements are enclosed in a box surrounded by a thin line. This helps to visually break the SQL code into command sections, and identifies blocks of SQL statements that can be graphically designed using Query Designer. For more information on using Query Designer, see Design Queries and Views How-to Topics (Visual Database Tools).

See Also

Design Queries and Views How-to Topics (Visual Database Tools)