Product update alerts
Join 80,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
SQL Refactoring techniques – How to split a table in SQL?
SQL database refactoring techniques – Rename method
SQL database refactoring techniques
Rules of SQL formatting – SQL naming conventions and capitalization rules
Rules of SQL formatting – SQL code commenting
Rules of SQL formatting – Commas and spacing in T-SQL
Rules of SQL formatting – Terminating SQL statements with semicolons
How to format SQL like a pro – formatting to implicit Microsoft standards and guidance
SQL code refactoring – ways to improve database performance – Part 1
SQL code refactoring – ways to improve database performance – Part 2
SQL code refactoring – ways to improve database performance – Part 3
Rules of SQL formatting – Regular and delimited T-SQL identifiers
SQL Formatting standards – Capitalization, Indentation, Comments, Parenthesis
SQL Formatting standards – joins, lists, structure, operations
Changing SQL stored procedures and functions parameters without breaking dependencies
Quickly convert SQL code to language-specific client code
How to prevent performance problems and errors due to wildcards in SELECT statements
Clean up SQL code from variables you don't use
Improve the performance of your SQL queries by qualifying object names
Secure your stored procedures against SQL injection
SQL code refactoring – ways to improve database design
How to rename database objects in a SQL Server database safely – Part 1
How to rename database objects in a SQL Server safely – Part 2
Replacing one-to-many relationships with association tables automatically– Part 1
Replacing one-to-many relationships with association tables automatically – Part 2
How to format a SQL query to qualify object names explicitly
SQL query basics – How to improve readability by formatting commas, spacing and alignment
SQL query basics – How to improve readability by formatting capitalization and object naming
How to safely modify SQL stored procedure and SQL function parameters
How to refactor a SQL Server database table to add a surrogate key
How to clean up SQL database code by removing unused parameters
How to refactor a SQL Server database by splitting a table
SQL database refactoring – Finding and updating internal references
SQL database refactoring – Introduction
SQL database refactoring techniques – Replacing a natural key with a surrogate key
How to format all SQL objects in your database
Copy SQL scripts into another programming language
ApexSQL named 2013 Community Choice Award winner by the Windows IT Pro Community
ApexSQL Refactor vs RedGate SQL Prompt Formatting – Common formatting options compared
ApexSQL Refactor vs RedGate SQL Prompt – Additional formatting options
ApexSQL Refactor vs RedGate SQL Prompt – Additional refactors
ApexSQL Refactor vs RedGate SQL Prompt - Additional formatting features
ApexSQL Refactor vs RedGate SQL Prompt Refactors – Common refactors compared "Encapsulate As"
Formatting screen mockups and examples datasheet
ApexSQL Refactor 2016 R1 – New features
ApexSQL Refactor 2016 R2 – Formatting option change impact analysis improvements
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!
See all of our
SQL Formatting and refactoring
SQL text and object search
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
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
Renewals and upgrades
© 2016 ApexSQL LLC | +1 (866) 665-5500 | firstname.lastname@example.org | email@example.com