Product update alerts
Join 100,000+ subscribers
Format and refactor SQL code and objects
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. Learn more
Format SQL scripts and script folders in batches
Make SQL code less readable
Transform * wildcards into explicit lists of column names. Learn more
Qualify columns with schema table names and schema or aliases. Learn more
Clean up your code by identifying and removing parameters and variables that aren’t used. Learn more
Rename tables, procedures, views, functions and columns risk-free. Learn more
Replace complex, multi-column primary keys with a single column surrogate key. Learn more
Add a new associative table to replace one-to-many relationships. Learn more
Add, remove or change parameters without breaking dependencies from referencing objects. Learn more
Convert blocks of SQL code into scalar or table functions, stored procedures and views. Automatically identify and create the input parameters. Learn more
Improve your database design and make large tables more manageable by partitioning them. Learn more
Render T-SQL into its Java, C#, C++, VB .NET, PHP, Ruby, Delphi or PowerBuilder equivalent. Learn more
This knowledgebase article 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
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
This artice shows how to use ApexSQL Refactor to automatically implement all SQL formatting rules to ensure the code is readable
This article describes how to use ApexSQL Refactor to clean up your code and remove unnecessary bloat
This article describes how to ApexSQL Refactor to split a table in SQL
This article provides some recommendations of using ApexSQL Refactor to format joins, value lists, code structure, arithmetic, comparison and logical operations
This article explains using a semicolon to terminate SQL statements, differences between the GO command and a semicolon
This article describes how to use ApexSQL Refactor to “wrap up” the existing code and create stored procedures and functions.
This article explains how to change parameters of your functions or stored procedures safely using ApexSQL Refactor
This article describes how to use ApexSQL Refactor to modify SQL functions parameters and stored procedures automatically
In this article, we describe how to implement MSDN, SQL Server online documentation, and Adventure Works formatting standards with ApexSQL Refactor
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
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
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
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 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!
I use ApexSQL Refactor for a couple of years and it helped me a lot in designing and throubleshooting stored procedures and long queries. Thanks for the high and specific customization that I didn’t find in other free products.
Decrypt SQL Server database objects
Execute scripts on multiple databases
Search SQL Server data and objects
Renewals and upgrades
© 2017 ApexSQL LLC | +1 (866) 665-5500 | email@example.com | firstname.lastname@example.org