For the best web experience, please use IE11+, Chrome, Firefox, or Safari

SQL formatter

ApexSQL Refactor is a SQL Server Management Studio (SSMS) and Visual Studio formatting and refactoring add-in for SQL Server with nearly 200 formatting options and 15 refactors such as table partitioning, safe rename, wildcard expansion and more.
An introduction to ApexSQL Refactor 08:25
Download Free Trial
SQL formatter
Overview Benefits Resources Related Topics
Download Free Trial

Benefits

  • SQL formatter with over 160 options

  • Qualify objects and expand wildcards

  • Encapsulate SQL into procedures

  • Add surrogate keys

  • Replace one-to-many relationships

  • Change procedure parameters

  • Safely rename SQL objects

  • Locate & highlight unused variables

  • Format SQL objects

  • Obfuscate SQL

Features

Impact analysis

Preview the impact of SQL formatter changes with difference highlighting

Advanced SQL formatting

SQL formatter with over 160 customizable options

SQL formatter profiles

Save and quickly toggle between different sets of formatting settings

Batch formatting of SQL objects

Use the database-level SQL formatter to format all script based objects e.g. stored procedures, in a database, quickly and easily. Learn more

Obfuscation

Make SQL code less readable

Wildcard expansion

Transform * wildcards into explicit lists of column names. Learn more

Object name qualifying

Qualify columns with schema table names and schema or aliases. Learn more

Find unused variables and parameters

Clean up your code by identifying and removing parameters and variables that aren’t used. Learn more

Safe rename

Rename tables, procedures, views, functions and columns risk-free. Learn more

Add surrogate key

Replace complex, multi-column primary keys with a single column surrogate key. Learn more

Replace one-to-many relationships

Add a new associative table to replace one-to-many relationships. Learn more

Change parameters

Add, remove or change parameters without breaking dependencies from referencing objects. Learn more

Encapsulate SQL

Convert blocks of SQL code into scalar or table functions, stored procedures and views. Automatically identify and create the input parameters. Learn more

Split table

Improve your database design and make large tables more manageable by partitioning them. Learn more

Convert to code

Render T-SQL into its Java, C#, C++, VB .NET, PHP, Ruby or Delphi equivalent. Learn more

Command Line Interface

Format SQL from the command line. Learn more

Related Topics

ApexSQL Refactor 2018 - Screen shot tour

ApexSQL Refactor 2018 - Screen shot tour

This article represents a screen shot tour of ApexSQL Refactor features with a brief description

ApexSQL Refactor - How to safely rename database objects without breaking dependencies

ApexSQL Refactor - How to safely rename database objects without breaking dependencies

This video shows how to use the Safe rename feature in ApexSQL Refactor and how to easily rename database objects without breaking any dependencies

ApexSQL Refactor formatting options - General options, capitalization and comments

ApexSQL Refactor formatting options - General options, capitalization and comments

This video shows how to set formatting options under the tabs formatting, capitalization and comments, so your SQL code becomes more readable

ApexSQL Refactor formatting options - Parameters, columns, joins, and flow control

ApexSQL Refactor formatting options - Parameters, columns, joins, and flow control

This video shows how to use ApexSQL Refactor and set formatting options under the parameters, columns, joins and flow control tabs, so your SQL code becomes more readable

ApexSQL Refactor - Overview

ApexSQL Refactor - Overview

This knowledgebase article briefly explains every feature/option in ApexSQL Refactor

Top things you need in a SQL formatter tool

Top things you need in a SQL formatter tool

This article lists top things a SQL formatter tool needs to have

How to format SQL like a pro - formatting to implicit Mircrosoft standards and guidance

How to format SQL like a pro - formatting to implicit Mircrosoft standards and guidance

In this article, we describe how to implement MSDN, SQL Server online documentation, and Adventure Works formatting standards with ApexSQL Refactor

SQL formatter rules - Nesting and indenting SQL statements

SQL formatter rules - Nesting and indenting SQL statements

This article explains nesting and indenting of SQL statements as another aspect of SQL formatter styles

Tips and tricks for using ApexSQL Refactor SQL formatting options - General options, Capitalization and Comments

Tips and tricks for using ApexSQL Refactor SQL formatting options - General options, Capitalization and Comments

This article provides an explanation of ApexSQL Refactor T-SQL code formatting options in the Formatting, the Capitalization, and the Comments tab

Tips and tricks for using ApexSQL Refactor SQL formatting options - Parameters, Columns, Joins, and Flow control

Tips and tricks for using ApexSQL Refactor SQL formatting options - Parameters, Columns, Joins, and Flow control

This article provides an explanation of ApexSQL Refactor T-SQL code formatting options under the Parameters, the Statements, the Joins, and the Flow control tabs

How to customize SQL formatting profiles

How to customize SQL formatting profiles

This article describes how to use ApexSQL Refactor formatting profiles and is a guidance through the process of managing profiles

How to formal all SQL objects in your database

How to formal all SQL objects in your database

This article shows how to format all SQL objects in a database with the specified formatting profile, without having to script them first

Quickly convert SQL code to language-specific client code

Quickly convert SQL code to language-specific client code

This article describes how to use ApexSQL Refactor convert your T-SQL script into a client language-specific syntax – Java, VB.NET, c#, Perl, PHP, Delphi, PowerBuilder, Ruby, C++, or other custom languages

SQL database refactoring - introduction

SQL database refactoring - introduction

This article explains what database refactoring is and what are the reasons for database refactoring

How to set options for the Split Table refactoring method on SQL Server

How to set options for the Split Table refactoring method on SQL Server

This article explains how to set the options in the Split Table refactoring method on SQL Server, using ApexSQL Refactor, to gain the best performance based on your needs

Changing SQL stored procedures and functions parameters without breaking dependencies

Changing SQL stored procedures and functions parameters without breaking dependencies

This article explains how to change parameters of your functions or stored procedures safely using ApexSQL Refactor

How to secure stored procedures against SQL injection

How to secure stored procedures against SQL injection

This article shows how to use ApexSQL Refactor to ensure all stored procedures are safe from SQL injection

Testimonials

Hostcentric Inc.

The ApexSQL Refactor SQL formatter is a great help, and I'm glad to have found something that works well and is easy!

Alex Gadea Sr. VP of Operations, Hostcentric Inc.

Software Developer Consultant

I'm a user of ApexSQL Refactor and I find it a really wonderful product.

Paolo FRANCESCHINI Software Developer Consultant

Jeeves Information Systems AB

I tried the ApexSQL Refactor product and liked it a lot. This is something I have been thinking would make my life a lot easier.

Mathias Hedlund System Developer, Jeeves Information Systems AB

PDP.com

I used ApexSQL Complete and ApexSQL Refactor. Both are well designed and include all the modern feature compare to other competitors. I found tons of customization options that makes your tools powerful.

Mohammad Sanati Software & Database developer, PDP.com

Communicus

ApexSQL Refactor is essential to keeping formatting standards on my team without getting overwhelmed. Everyone can format as they want, but when it’s production-ready, it all fits the standard. I reach for the formatter after every edit; it’s second-nature.

Steven Hibble Senior Database Developer, Communicus

Get started now

Seamlessly integrate a SQL query formatter directly into SQL Server Management Studio (SSMS) and Visual Studio.
Download Free Trial