How to customize formatting styles with profiles

Last modified: September 8, 2023

A formatting profile is a saved set of options that help layout and beautify SQL code. SQL Complete includes two groups of formatting profiles - Devart and Custom. The Devart profiles are the default profiles that come with the tool.

Here is the list of the predefined formatting profiles:

• Collapsed
• Commas before
• Compact
• Default
• Extended
• Indented
• MSDN SQL
• Right aligned
• Stack compact

To learn how to create and customize formatting profiles in SQL Complete, see Profiles.

Select and apply a formatting profile

To select a style to be applied, right-click the query window, click Active Format Profile and choose one of the predefined formatting profiles. After that, format the query document by pressing Ctrl+K, then Ctrl+D.

Set a preferred formatting profile

By default, the active formatting profile in SQL Complete is the built-in Default formatting profile. In order to set a different style from the default one, do the following:

1. On the SQL Complete menu, click Options.
2. In the Options window, go to the Formatting > Profiles tab.
3. Choose one of the predefined formatting profiles.
4. Click Set as Active.
5. Click OK.

Modify a formatting profile

Predefined profiles cannot be modified. However, you can use the settings of these profiles as a basis for your own custom profiles to beautify your SQL code. Just do the following:

1. On the SQL Complete menu, click Options.
2. In the Options window, go to the Formatting > Profiles tab.
3. Choose one of the predefined formatting profiles.
4. Click Open Selected.
5. Edit formatting options in the left-hand pane.
6. Click Save As.
7. Enter a name for your new custom profile.
8. Click OK.

Create a new formatting profile

1. On the SQL Complete menu, click Options.
2. In the Options window, go to the Formatting > Profiles tab.
3. Click Create New.
4. Enter a name for your new profile.
5. Click OK.

Helpful materials

How to Compare Two Formatting Styles in dbForge SQL Complete

Learn how to make changes to a formatting style and create a customized profile.