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
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. |
Want to find out more?
Overview
Take a quick tour to learn all about the key benefits delivered by dbForge Studio for SQL Server.
All features
Get acquainted with the rich features and capabilities of the tool in less than 5 minutes.
Request a demo
If you consider employing this tool for your business, request a demo to see it in action.