SQL Server 2008 - Keyboard Shortcut Key to do SQL Query Formatting

Do y开发者_开发问答ou know the Keyboard shortcut key in SQL Server 2008 Management Studio to do SQL Query Formatting?

I hope this will help future readers if OP is already found the solution.

There is no built in formatting in SSMS but there are free SSMS Addins such as ApexSQL Refactor you can use for this.

Apart from this you can also try SSMS tools pack but note that it’s not free for SQL 2012.

Another great tool for this is Red-Gate SQL Prompt Pro which allows you to define your own SQL coding style, and easily reformat any crappy SQL code that gets dumped on you :-)

It's not free - but easily worth every penny it costs!

there are no built in formatting functions like a Beautifier or Formatter program.

tab (including while a section of code is selected), space, backspace, delete, etc. and the expected ones. I use alt+mouse click+drag to select "square" sections of code.

here are all of the SQL Server Management Studio Keyboard Shortcuts

Are you looking for something like this: Format SQL Beautifier software ??

Ctrl + Shift + Q will give you a Query Designer window from which you can copy formatted query.

Their is no shortcut keys in sql server 2008,2010,2014,2015...

The simple way visit http://www.sql-format.com/ and format.