In the Comments tab, comments can be set to suit your needs, you can add an empty line before and after block comments or add borders above/below block comments using any separates such (*, -, +, /). In the Capitalization tab, capitalization style can be set for SQL keywords, data types, identifiers, system functions and variables using options from combo box such upper case, lower case, upper/lower camel case, and proper case: The Empty lines section contains options for manipulating empty lines, you can remove or add empty lines before/after comments, remove/add empty lines before each statement, change several empty lines into one empty line: Additionally, you can add spaces around assignment operator or add spaces before and after the commas. You can limit number of characters that applies per line by adjust wrapping option on the desired length.
![sql code formatter sql code formatter](https://rogerulrich.ch/wordpress/wp-content/uploads/2017/06/sqlserverversions.png)
Aligns identifiers in the data statements using Smart indent option. In the Formatting tab, can be set the indentation by using spaces or tabs. All options are grouped in tabs and sub-tabs. You can modify built-in formatting profiles or created your on user defined formatting profile using numerous of options from Options form, which is located under the ApexSQL Refactor menu. To format SQL code inside Microsoft SQL Server Management Studio or Visual Studio select code in the query window and from the Format SQL sub-menu, choose one of the four build-in formatting profile:Īnother way to access the formatting profiles is via ApexSQL Toolbar:
![sql code formatter sql code formatter](https://community.wappler.io/uploads/default/original/3X/4/e/4eb56c6876c12d19bce3b76859cc3e1fc2e35d1f.gif)
The add-in can be integrated into Microsoft SQL Server Management Studio and Visual Studio. You can qualify object names, expends wildcard, encapsulate SQL code, renames SQL database objects and parameters without breaking dependencies.
![sql code formatter sql code formatter](https://i.imgur.com/MfpCTJk.png)
#Sql code formatter free#
Let us learn about SQL Server Formatting Add-in.ĪpexSQL Refactor is a free add-in with over 200 formatting options and nearly 15 code refactors. This article describes the ways in which you can format SQL code using ApexSQL Refactor features and options.