Lay Out SQL

The Lay Out SQL refactoring reformats your SQL code to make it more readable without changing its behavior.

To lay out the SQL code in the current SQL Server Management Studio query editor:

1. Set the SQL Layout options as required.
2. On the SQL Refactor menu, click Lay Out SQL.

   SQL Refactor lays out your code according to the options you have set. Note that not all commands are fully supported by the Lay Out SQL refactoring; for these commands only the wrapping option is applied.

If your SQL code contains syntax errors, SQL Refactor cannot lay out the code. An error is displayed, and the incorrect code is underlined in the query editor.