Product update alerts
Join 90,000+ subscribers
Format and refactor SQL Server code and objects for free in SSMS and Visual Studio
SQL code formatter with over 160 customizable options
Preview the impact of changes with difference highlighting
Save and quickly toggle between different sets of formatting settings
Allows the formatting of all script based objects e.g. stored procedures, in a database, quickly and easily
Format SQL scripts and script folders in batches
Make SQL code less readable
Transform * wildcards into explicit lists of column names
Qualify columns with schema table names and schema or aliases
Clean up your code by identifying and removing parameters and variables that aren’t used
Rename tables, procedures, views, functions and columns risk-free
Replace complex, multi-column primary keys with a single column surrogate key
Add a new associative table to replace one-to-many relationships
Add, remove or change parameters without breaking dependencies from referencing objects
Convert blocks of SQL code into scalar or table functions, stored procedures and views. Automatically identify and create the input parameters
Improve your database design and make large tables more manageable by partitioning them
Render T-SQL into its Java, C#, C++, VB .NET, PHP, Ruby, Delphi or PowerBuilder equivalent
This datasheet contains mockups and examples for the most important formatting options in ApexSQL Refactor, such as Comments, Capitalization, Expressions, Schema Statements, Data Statements, Joins, and more
In this article, we describe how to implement MSDN, SQL Server online documentation, and Adventure Works formatting standards with ApexSQL Refactor
This article describes how to use the Wildcard expansion code refactor of ApexSQL Refactor as an effective way to improve SQL query performance and prevent errors related to wildcards in SELECT statements as well as improving the quality and readability of SQL code
This article describes how to quickly and completely risk-free replace one-to-many relationships with association tables to increase the robustness, efficiency and clarity of the database design
This article explains how to use the Format SQL objects feature to format one or more database objects with the specified formatting profile, without having to script them first
That did the trick - very, very, very cool!!!! Being very particular about formatting my SQL makes this product a definite buy because it can support almost endless formatting scenarios!
The Stellar Group
The ApexSQL Refactor is a great help, and I'm glad to have found something that works well and is easy!
Sr. VP of Operations
Great product. I can't wait to see what you'll add next!
Big Foot Software Research and Development
Carson City, NV
VP Database Services
I'm a user of ApexSQL Refactor and I find it a really wonderful product.
Software Developer Consultant
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.
Jeeves Information Systems AB
Whether or not I get the privilege of becoming part of your paying ApexSQL team, I’m already a free member who loves your Refactor and Search immensely! :)
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.
Software & Database developer
I’ve been using sql refactor for many years now and love it! When working in a team of developers, I use to get caught up/side tracked/lost in the “uniqueness” of each developer’s sql style. After I started using sql refactor, that was never the case again. Now we pass it around, reformat, and can work on it in our styles.
Database Programmer Analyst
I tried out Refactor, and it’s awesome!
I mainly use Refactor as it saves me a lot of time making my code easier to read. I could of course do this as I go along but it is much more time consuming (and I don't have much time!).
Technical Support Executive
I just created account on Your site and minutes later I had ApexSQL Complete and Refactor installed.
I must say I was amazed what those apps can do and that they are free.
Thanks for whole team for creating such amazing software and for releasing it for free. You guys are amazing!
I’ve been using ApexSQL Refactor for about three years now and have found it to be the most customizable of any product on the market today. And it is FREE! Kudos to your development team!
ApexSQL Refactor 2016.01
Redgate® SQL Prompt 7
Comparison was conducted on January 20, 2016
Redgate® SQL Prompt also includes Auto-complete. For a comparison of this functionality set click here
Disclaimer: All product and company names are trademarks™ or registered® trademarks of their respective holders.ApexSQL is not affiliated, associated, authorized, endorsed by, or in any way officially connected with other companies listed or any of their subsidiaries or affiliates
See all of our
SQL Formatting and refactoring
SQL text and object search
Renewals and upgrades
© 2016 ApexSQL LLC | +1 (866) 665-5500 | firstname.lastname@example.org | email@example.com