Format SQL Script in Visual Studio 2012

visual-studio-2012 format sql-server-data-tools
Nexus23 picture Nexus23 · Feb 21, 2013 · Viewed 7.1k times · Source

Normally we can format code or markup in visual studio with Ctrl + K + D shortkeys.

How we can format SQL script code like stored procedures or views or other things using shortkeys?

Note: I am using SSDT with VS2012, where I can edit scripts of a database, but I can't find format option.

Answer

Peter Schott picture Peter Schott · May 1, 2013

I don't think there's a built-in SQL Format option for SSDT. You can use a plug-in such as Red-Gate's SQL Prompt to get that functionality, but I don't think there's a native option for formatting SQL at this time.

Related questions

How to auto format code indentations in VS2012?

How to auto format code in VS2012 to save time typing and deleting spaces and tabs?

Read More
Error 'LINK : fatal error LNK1123: failure during conversion to COFF: file invalid or corrupt' after installing Visual Studio 2012 Release Preview

I've installed Visual Studio 2012 Release Preview, and it appears to be fine, but now when I try to use Visual Studio 2010 to compile C++ projects, I get the following error message: LINK : fatal error LNK1123: failure during conversion to COFF: …

Read More
Is there a format code shortcut for Visual Studio?

In Eclipse there is a shortcut, Ctrl+Shift+F, that re-indents code and fixes comments and blank lines. Is there an equivalent for Visual Studio 2010?

Read More