Bi-weekly updates
Exclusive discounts
Product update alerts
Join 120,000+ subscribers
Seamlessly integrate a SQL query formatter directly into SSMS and Visual Studio
Preview the impact of SQL formatter changes with difference highlighting
SQL formatter with over 160 customizable options
Save and quickly toggle between different sets of formatting settings
Use the database-level SQL formatter to format all script based objects e.g. stored procedures, in a database, quickly and easily. Learn more
Use the bulk SQL formatter to process 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 or Delphi equivalent. Learn more
Format SQL from the command line. Learn more
This article represents a screen shot tour of ApexSQL Refactor features with a brief description
This video shows how to use the Safe rename feature in ApexSQL Refactor and how to easily rename database objects without breaking any dependencies
This video shows how to set formatting options under the tabs formatting, capitalization and comments, so your SQL code becomes more readable
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
This knowledgebase article briefly explains every feature/option in ApexSQL Refactor
This article lists top things a SQL formatter tool needs to have
In this article, we describe how to implement MSDN, SQL Server online documentation, and Adventure Works formatting standards with ApexSQL Refactor
This article explains nesting and indenting of SQL statements as another aspect of SQL formatter styles
This article provides an explanation of ApexSQL Refactor T-SQL code formatting options in the Formatting, the Capitalization, and the Comments tab
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
This article describes how to use ApexSQL Refactor formatting profiles and is a guidance through the process of managing profiles
This article shows how to format all SQL objects in a database with the specified formatting profile, without having to script them first
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 article explains what database refactoring is and what are the reasons for database refactoring
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
This article explains how to change parameters of your functions or stored procedures safely using ApexSQL Refactor
This article shows how to use ApexSQL Refactor to ensure all stored procedures are safe from SQL injection
ApexSQL Refactor 2021.02
Redgate® SQL Prompt 10.5.0.16982
Comparison was conducted on December 11, 2020
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 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.
I'm a user of ApexSQL Refactor and I find it a really wonderful product.
Paolo FRANCESCHINI
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.
Mathias Hedlund
System Developer
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.
Mohammad Sanati
Software & Database developer
PDP.com
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
© 2022 Quest Software Inc. ALL RIGHTS RESERVED. | GDPR | Terms of Use | Privacy