Resolve

issues faster

Database Tools

Must-have SQL Server tools and tools for MySQL, Oracle, and PostgreSQL database development, management and administration

Data Connectivity

The most trusted solutions for your data connectivity needs: ADO.NET, ODBC, SSIS, Excel, dbExpress, Delphi Components

Productivity Tools

Write code, create reviews, compare sources, track the working hours with the web app, utilize the power of ORM Solutions

Data Services

Data integration, online backup, web-based SQL tools, cloud connectivity solution

SQL Complete - SQL Code Formatter for SQL Management Studio

Beautify your SQL and T-SQL statements paying attention to case, line breaks, whitespaces, indenting, wrapping, etc straight in SQL Server Management Studio. Devart's SQL Code Formatter provided by dbForge SQL Complete, is one of the best and most advanced code formatting solutions available on the market that allows you to customize the way your document will be formatted by setting the corresponding options as well as to preview the result.

With Code Formatter, you can:

  • Make your SQL code look pretty and be easier to read, understand, debug, and test.
  • Increase your productivity and save a lot of time: forget about SQL query formatting when creating, reformatting it, or making modifications.
  • Introduce unified SQL code formatting standard or your company, no matter if it is a big enterprise or a small project team.
  • Protect formatted code from syntax errors: if there are any syntax errors in the SQL document that is being formatted, the inner parser will not generate the parsing tree and the document will not be formatted.
  • Minimize memory overload: formatter does note require much memory even if an SQL document is large. We've tested the formatter's work with a 130MB SQL document.

Customization settings

Formatting behavior can be easily set up according to your preferences. You can tune automatic formatting options, margin, syntax error behavior and more.

Formatting Profiles

SQL Complete includes a collection of predefined formatting profiles. The profiles can be easily modified up to your needs. Moreover, you can create your own profiles that would meet your formatting standards the most.

Bulk formatting

The tool comes with SQL Formatter Wizard allowing to perform a bulk formatting of selected files or the whole file directories.

Disabling formatting for a certain block of code

With the -- noformat -- endnoformat tags, you can format a whole SQL document in the editor ignoring selected code fragments which you do not want to be formatted.

Availablilty

Features

Exp

Std

SQL formatting
Partially supported
Yes
Formatting in files and directories
No
Yes
Disable formatting for a certain block of code (noformat tag)
No
Yes