ApexSQL Refactor

Transform your code

A powerful formatting tool
      A collection of amazing code refactors

Value bundles
Refactor is included in
  • All 13 ApexSQL developer tools
  • 1 year free support and upgrades
Related products
"The Refactor is a great help, and I'm glad to have found something that works well and is easy!"

Michael Jenkins, Programmer/Analyst, International Mission Board

see more

Format and refactor code directly in SSMS or VS for FREE

Qualify objects, expand wildcards, encapsulate SQL and more

Locate and highlight unused variables and parameters

11 code refactors and over 160 customizable formatting options

ApexSQL Refactor introduction video thumbnail

 Datasheet: Formatting screen mockups and examples

Consistent code layouts

Improve readability, consistency and standardization with SQL formatting. Easily define and share SQL coding standards among multiple developers

Explicit coding

Clean up sloppy SQL code and eliminate implicit references by fully qualifying object names and replacing wildcards with actual column names

Code re-use

Convert SQL into a variety of popular client programming languages. Encapsulate lengthy blocks of SQL into database objects like views and procedures

Risk free SQL refactoring

Automatically update all dependent database objects on renaming or changing columns and parameters

Clean SQL code

Automatically highlight unused parameters and variables while typing

Modular development

Encapsulate lengthy blocks of SQL code as views, functions and procedures

Database design refactoring

Streamline your database design by replacing one to many relationships with associative tables. Leverage the performance benefits of replacing natural with surrogate keys and splitting large tables

Parameter management

Add or remove parameters and change their names, default values or data types without breaking dependencies