How to customize formatting styles with profiles

A formatting profile is a saved set of options that help layout SQL code. dbForge Query Builder for SQL Server includes two groups of formatting profiles - Devart and Custom. The Devart profiles are the predefined profiles that come with the tool.

The predefined formatting profiles include:

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

Setting 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. In the Tools menu, click Options.
  2. In the Options window, go to Formatting > Profiles.
  3. Choose one of the predefined formatting profiles.
  4. Click Set as Active.
  5. Click OK.

Modifying a preferred formatting profile

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

  1. In the Tools 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 the Save As button.
  7. Enter a name for your new custom profile.
  8. Click OK.

Creating a new formatting profile

  1. In the Tools 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.

Want to Find out More?

Overview

Overview

Take a quick tour to learn all about the key benefits delivered by dbForge Query Builder for SQL Server.
Request a demo

Request a demo

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