Code Formatting
Formatting options
Formatting behavior can be easily configured as required, including automatic formatting options, margin, syntax error behavior, and more.
Formatting in files
The tool comes with SQL Formatter Wizard allowing to perform a bulk formatting of selected files or the whole file directories.
To learn how to use dbForge Source Control to collaborate in a team, you can watch this video.
Noformat tag
With --noformat --endnoformat tags, you can point out where to stop formatting the SQL document and where to start formatting again.
Wide range of predefined formatting profiles
SQL Complete includes a collection of predefined formatting profiles. The profiles can be easily modified up to your needs. Moreover, you can create your own profiles that would meet your formatting standards the most.
Database identifier case synchronization
If your database identifiers were created according to certain rules adopted in your development environment, then you will have no problems with transforming the case of SQL script identifiers to match that of the database.
Word recognition in CamelCase identifiers
For multipart and single-word identifiers, this feature will make each word start from the capital letter. The dictionary.txt file should contain these words to make them susceptible to CamelCase formatting.
Adjust keyword case on typing
This feature saves you a lot of time as you type code phrases as you don't need to switch between the upper case and lower case to make your code look pretty and compliant with a specific code convention.
Automatically format completed statement on semicolon
This feature provides the opportunity to automatically format SQL statements after a semicolon is inserted at the end of the statement. The formatting is processed in accordance with the currently active profile settings.
Automatically format on paste
Automatically format expressions inserted from the clipboard into the SQL document based the currently active formatting profile settings.
Database letter case coherence
This functionality allows defining words for compound identifier names. While formatting identifiers in CamelCase, the compound words of the identifier will be automatically determined, and each word in it will begin with the capital letter. The dictionary consists of a set of individual keywords that can be included to the objects identifier.
SQL formatting CLI
You can automatically format SQL files and SQL scripts folders as a pre-commit hook or as a continuous integration (CI) validation step, which can automate and greatly simplify time-consuming routine DevOps tasks.
Also, feel free to watch this video to learn how to format SQL script files from the command line and how to automate the process.
CLI formatter wizard
SQL Complete features a built-in SQL formatting command-line interface - the Command Line Execution File Settings wizard. It helps users automate and manage code formatting tasks. This wizard allows users to create a batch file containing a script with customizable options for formatting code. To access the wizard, navigate to the SQL Formatter Wizard from the SQL Complete main menu by selecting SQL Formatter. In the wizard, choose the file or folder you want to format and click Save Command Line to generate the script.
Also, feel free to watch this video to learn how to format SQL script files from the command line and how to automate the process.