Formatting options

Last modified: July 9, 2025

dbForge Studio for SQL Server can help you configure formatting options using the Options dialog, the Formatting and Profiles pages.

To open the Options dialog, on the Tools menu, select Options. In the Options dialog that opens, navigate to Text Editor > Formatting.

Formatting: General

General formatting options are grouped into three categories:

  • Formatting
  • Notifications
  • Dictionary

General formatting options

Formatting

Here you can select how your code will be formatted: immediately on paste, after you add a delimiter to a completed statement, or automatically when typing.

The Right Margin option allows you to specify the code line length in symbols. The default value is 80.

Note

Right Margin is a base point for formatting rules applicable for different statements, for example, Wrap condition when the margin is exceeded and Single line when the margin is not exceeded.

Turn off formatting for a piece of code

You can format an entire SQL document in the editor ignoring the selected code fragments. With the noformat and endnoformat tags, you can point out where to stop formatting and where to start formatting again.

To turn off formatting for a piece of code, use the following:

noformat
...
endnoformat

Notifications

In the Notifications group, all options are selected by default, including showing syntax errors in the Output window and displaying syntax error notifications. To turn off either of these features, clear the corresponding checkbox.

Dictionary

The default path to store a dictionary file is C:\ProgramData\Devart\dbForge Studio for SQL Server\Dictionary.txt. To set a different path, specify it in the Dictionary file box.You can edit the dictionary and add or delete the names. When the Initial caps each word formatting option is enabled, words found in the dictionary will be capitalized.

The Available prefixes box lets you define specific prefixes that should not be capitalized when this option is active. To enter multiple prefixes, separate them with a semicolon.

Note

You can enable\disable the Initial caps each word option when configuring the specific profile.

Formatting: Profiles

A formatting profile comprises a set of rules for how to layout your SQL.

The table explains what actions you can perform on formatting profiles.

Action Description
Create New Opens the New Profile window to create a formatting profile.
Add Existing Adds the previously created profile.
Open Selected Opens the Configure Formatting Profile dialog for the selected profile.
Set as Active Activates the selected formatting profile.