How to customize formatting styles with profiles

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.

Want to Find out More?

Overview

Overview

Take a quick tour to learn all about the key benefits delivered by dbForge SQL Complete for SQL Server.
All Features

All features

Get acquainted with the rich features and capabilities of the SQL Complete in less than 5 minutes.
Request a demo

Request a demo

If you consider employing the SQL Complete for your business, request a demo to see it in action.
Ready to start using dbForge SQL Complete for SQL Server?
Download a free 14-day trial