Code Formatting

Formatting options and styles

Formatting behavior can be easily set up according to your preferences. You can tune automatic formatting options, margin, syntax error behavior and more. 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.

Formatting in files

The tool comes with SQL Formatter Wizard allowing to perform a bulk formatting of selected files or the whole file directories.

Noformat tag

With the -- noformat -- endnoformat tags, you can format a whole SQL document in the editor ignoring selected code fragments which you do not want to be formatted.

Database identifier case synchronization

If your database identifiers were created according to certain adopted rules, then you will have no problems with transforming SQL script identifier case to that of the database.

Word recognition in CamelCase identifiers

You don't need to type the entire Camel case phrase, simply type the first letters of its "humps", and SQL Complete will recognize the specific identifier you need and show it in the prompt list.

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.

SQL formatting command-line interface

You can automatically format SQL files as well as SQL scripts folders as a pre-commit hook or as continuous integration (CI) validation step, which can greatly simplify the DevOps routine tasks.

Automatically format completed statement on delimeter

The feature provides the opportunity to format SQL statements after inserting semicolons automatically. Formatting is processed in accordance with active profile settings.

Automatically format on paste

This functionality allows formatting the expressions inserted from the buffer into the SQL document automatically. It works in accordance with the 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.