Help N++ Plugin & Windows App

Database Drop Down Menu

With the DB drop-down box you can choose between all major Databases. Many new Databases have been added with Releases 6.0. All of them have a basic set of parsing rules which can easily be extended.

Please use the forum to request for new keywords.

Sql Formatter Sqlinform

General Indention

There are many places where the beautifier adds spaces to align the SQL nicely. The size of the indention can be adapted using the „General Indention“.

Sql Indent General Space Option 2

SQL Indention

Large Keyword Size

But sometimes we want nice alignment for the main SQL tokens. They should be aligned with the main keywords. In the SQL below the largest keyword is „left outer join“ and therefore all tokens are aligned to „left outer join„.

The indention for case keywords is still the size mentioned in „General Indention“.

Sql Indent Large Size

Small Keyword Size

If „Large Keyword Size“ does not fit to your need you can choose „Small Keyword Size“. SQLinForm will look to all the main keywords:

select, from, left outer join, where, order by, group by

and take the size of the largest first word of the keywords to determine the indention size which is in this example the size of „select“ keyword. „select“ is larger than from, left, where, order, group

The indention for case keywords is still the size mentioned in „General Indention“.

Sql Indent Small Size

General Indention

If you want the same indention for the SQL main keywords as everywhere just leave the SQL Indention set to „General Indention“.

Sql Indent General Space Option