Sql indentation in SQL Server Management Studio

Question

Folks, is there a tool to format/indent SQL Server queries in query window ?

There should be same option like we have in visual studio built in. Ctrl + K + D — Kamran Shahid, Jan 17 '11 at 07:10

score 8 · Answer 1 · answered Dec 07 '10 at 16:53

8

With Apex SQL Refactor, you can specify your formatting preferences and reformat selected code or the entire window at any time using a keyboard shortcut. There's a free version.

ApexSQL Refactor

answered Dec 07 '10 at 16:53

srmark

7,942
13
63
74

AdaTheDev · Accepted Answer · 2010-02-03T17:51:44.683

6

+1 to JackM.

Just add a mention for some other (not free) tools available from Red Gate, depending on exact requirements.

SQL Prompt
SQL Refactor

Might be something you'd be interested in.

edited Feb 03 '10 at 17:51

answered Feb 03 '10 at 17:35

AdaTheDev

142,592
28
206
200

SQL Refactor -> Layout Sql seems more like it... – SoftwareGeek Feb 03 '10 at 17:50

score 2 · Answer 3 · answered Feb 03 '10 at 17:31

2

Format code in SQL Management Studio

answered Feb 03 '10 at 17:31

Jack Marchetti

15,536
14
81
117

Not quite like the way i wanted but nevertheless useful. – SoftwareGeek Feb 03 '10 at 17:57

score 2 · Answer 4 · edited May 23 '17 at 12:24

2

Older question which has much more activity and more answers: SQL Formatter for SQL Management Studio

My contributon to this mess is Poor Man's T-SQL Formatter / http://poorsql.com - free, open-source, does bulk formatting from command-line, SSMS plugin, etc, and (in theory) handles all SQL syntax up to SQL Server 2008 (R2).

edited May 23 '17 at 12:24

Community

1
1

answered Dec 21 '11 at 15:40

Tao

13,457
7
65
76

Sql indentation in SQL Server Management Studio

4 Answers4