Is it possible to auto-indent a query in Sql Server Management Studio Express?

Question

I mean, something equivalent to Ctrl + K + D from Visual Studio that automatically indents code. Is there something in this sense?

Thes SQL Formatter at www.sqlinform.com has a window hotkey function which could do the same — Guido, Aug 24 '14 at 18:20

score 21 · Answer 1 · edited May 23 '17 at 10:31

21

Just discovered this - yet another variation on this older question which has much more activity: SQL Formatter for SQL Management Studio

I personally am a big fan of the Poor Man's T-SQL Formatter / http://poorsql.com - but then I wrote it :)

edited May 23 '17 at 10:31

Community

1
1

answered Dec 21 '11 at 15:33

Tao

13,457
7
65
76

1

Please accept my upvote, kind sir. – third_eye Mar 14 '14 at 17:15
1

Thank you for making the poor man's tsql formatter. You've saved a lot of hours here. – Lorraine May 21 '19 at 14:36

score 16 · Answer 2 · answered May 30 '13 at 08:29

16

By default no but you can always try a third party tools like SQL Prompt mentioned above or ApexSQL Refactor (slightly less options compared to SQL Prompt but it’s a free product) or just use online formatter.

answered May 30 '13 at 08:29

Orland Mendes

516
4
5

score 10 · Answer 3 · edited Mar 29 '12 at 11:40

10

SQL Prompt from Red Gate can do this.

If you just want simple formatting online then the same technology powers FormatSQL.com

edited Mar 29 '12 at 11:40

answered Jan 19 '10 at 01:38

Mitch Wheat

295,962
43
465
541

Looks like a great product! It's just too bad it's so pricey! (Around $300 at the time of this post) – Dubs Feb 02 '10 at 14:36
Format SQL is great! Thanks! I wonder why there is no inbuilt function for thid. – TheGateKeeper Apr 26 '12 at 10:09

score 3 · Answer 4 · answered May 12 '11 at 04:10

3

SQL Pretty Printer can also reformat SQL. Available as a stand alone app or a SSMS plugin. Free to download (with a nag screen but no other apparent limitations) from http://www.dpriver.com

There is an online version at http://www.dpriver.com/pp/sqlformat.htm?ref=g_wangz

answered May 12 '11 at 04:10

ChrisWerry

135
3

Standalone download version can't save or be copied to the clipboard. – JohnL4 Sep 27 '12 at 21:12

score 1 · Answer 5 · answered May 30 '13 at 21:54

There is also the SQLinForm formatter. It is an automatic SQL code formatter for all major databases including ORACLE, SQL Server, DB2, UDB, Sybase, Informix, PostgreSQL, Teradata, MySQL, MS Access etc. with over 100 formatting options.It has a windows hotkey add-on, so you can use it in SSMS. Link: www.sqlinform.com

Is it possible to auto-indent a query in Sql Server Management Studio Express?

5 Answers5