What is the equivalent of Ctrl + K + D (Visual Studio) in Sql Server Management Studio which is use to format the code ?
3
-
1possible duplicate of SQL Formatting ToolCurtis– Curtis2011-09-12 08:58:31 +00:00Commented Sep 12, 2011 at 8:58
-
1Possible duplicate of SQL Formatter for SQL Management Studioicc97– icc972018-03-19 11:20:07 +00:00Commented Mar 19, 2018 at 11:20
-
@Curt that question is now closed as a duplicate of SQL Formatter for SQL Management Studio. Plus this one at the bottom of the rabbit hole is closed too.icc97– icc972018-03-19 11:21:56 +00:00Commented Mar 19, 2018 at 11:21
Add a comment
|
1 Answer
Upcoming SQL Server 2011 seems to have a similar feature, but previous versions doesn't have it. Click on the referenced link and you will see that;
- Applies the indenting and space formatting for the language specified on the Formatting pane of the language in the Text Editor section of the Options dialog. Available only in the text editor. ( CTRL-K, CTRL-D )
- Correctly indents the selected lines of code based on the surrounding lines of code ( CTRL-K, CTRL-F )
1 Comment
icc97
As far as I can tell, this is only for formatting XML, at least in Management Studio 17. There is no 'Formatting' pane for Transact-SQL in the options dialog, only for XML