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.
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.
Click OK to continue browsing the Devart site. Be aware you can disable cookies at any time.