New Formatting Profiles in SQL Complete v6.3
Tags: sql, sqlserver, dbforge, database
Published: 2019-12-19 15:53:25

---
title: New Formatting Profiles in SQL Complete v6.3
published: true
description: Devart released the next version of dbForge SQL Complete with new formatting profiles and the handy ability to quickly switch between them.
tags: SQL, SQL Server, dbForge, database
---
*Devart released the next version of dbForge SQL Complete with new formatting profiles and the handy ability to quickly switch between them.*

Devart, a recognized vendor of professional database management software for developers and DBAs, introduced span-new formatting profiles for one of its key solutions, [dbForge SQL Complete 6.3](https://www.devart.com/dbforge/sql/sqlcomplete/). Along with elegant code formatting via various styles, users now able to switch quickly to an alternative style or apply formatting specifically to certain parts of their SQL script.

Having a range of formatting styles at hand can assist in enforcing consistent coding styles at the company. It might be useful to utilize different formatting profiles for different purposes, such as reviewing code versus committing code to source control. With the new SQL Complete version users got a notably extended number of formatting profiles which includes:

■ **Default** — this is the default active profile;
■ **Collapsed** — the formatting option enables to collapse blocks of code in one line so that users can clearly see the sequence of statements in a document;
■ **Commas before** — under this formatting profile commas will be added before column names in SQL statements, helping avoid errors and eliminating the need to search through the whole document to find a missing comma;
■ **Indented** — indenting makes SQL code easier to follow, as it makes it visually structured;
■ **Right aligned** — under this formatting style, query keywords are right-aligned which beautifies the code and makes it easier to navigate through;
■ **Compact** — in this formatting style, all indentations are set to be zero spaces and all empty lines are removed from the query to make SQL code look denser;
■ **Extended** — under this profile SQL script is expanded with additional empty lines (before and after every statement and comment);
■ **MSDN SQL** — the formatting profile represents formatting rules used in the MSDN resource site.

The opportunity to switch between profiles in one click is also beneficial. Users can work in a profile they prefer, then switch to the profile their team works in, and finally shift to the company or customer style while delivering the results. Meanwhile, choosing a formatting profile doesn’t affect the code itself, but only impacts the SQL document layout.

For more information about the recent release of dbForge SQL Complete, please visit — https://blog.devart.com/new-formatting-profiles-added-and-existing-ones-redesigned-in-sql-complete-6-3.html

**About Devart**

Devart is one of the leading developers of database tools and administration software, ALM solutions, data providers for various database servers, data integration and backup solutions. The company also implements Web and Mobile development projects.
For additional information about Devart, visit https://www.devart.com/