Format SQL statements in SQL Server Management Studio 2008

Question

I am trying to use Ctrl K + Ctrl D (format document) in SQL Server Management Studio. It gives the message

The key combination (key, key) is bound to command(command) which is not currently available.

I also tried Ctrl A + Ctrl K + Ctrl F, and that didn't work either.

Is there any update or fix that I need to install for that?

Did you mean SQL Server Management Studio? – p.campbell Dec 20 '11 at 21:03 — p.campbell, Dec 20 '11 at 21:03

score 19 · Accepted Answer · edited May 23 '17 at 10:30

19

There is nothing to fix - SQL Server Management Studio is not Visual Studio and does not contain a SQL pretty printer.

In other words, SSMS does not have a document formatting option out of the box.

edited May 23 '17 at 10:30

Community

answered Dec 20 '11 at 21:04

Oded

score 1 · Answer 2 · edited Mar 29 '17 at 12:47

1

I was struggling with this, Finally found this Ctrl +K, Ctrl+Y and it worked for me. But you need to have SQL Prompt.

edited Mar 29 '17 at 12:47

Nilay Vishwakarma

answered Mar 29 '17 at 11:23

Kunal Prajapati

2 Answers2