A bi-weekly newsletter
Product update alerts
Join 40,000+ subscribers and growing
Format and refactor SQL Server code and objects for free in SSMS and Visual Studio
Layout your SQL code with over 160 customizable options
Preview the impact of changes with difference highlighting
Save and quickly toggle between different sets of formatting settings
Format SQL scripts and script folders in batches
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
How to improve query performance and avoid syntax errors by expanding wildcards in SQL statements
Tips and tricks for using ApexSQL Refactor SQL formatting options – General options, Capitalization and Comments
Tips and tricks for using ApexSQL Refactor SQL formatting options – Schema statements, Data statements, Joins, and Flow control
How to refactor SQL databases with ApexSQL Refactor
Rules of SQL formatting – Nesting and indenting SQL statements
Avoid implicit name resolution of objects in queries by qualifying object names
How to encapsulate code as a new stored procedure, a function, or a view
How to set options for the Split Table refactoring method on SQL Server
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"
Source Control support for ApexSQL products
Formatting screen mockups and examples datasheet
SQL Server – How to Format and Refactor Your SQL Code Directly in SSMS and Visual Studio
5 Free SQL Server Tools to Give You a Boost
Best Free SQL Server Tool of 2013 - Community Choice Awards
SQL Query Formatting – Putting Lipstick On A Pig
Top Free SQL Tools
Free Tool for SQL Code Refactoring
Want to promote your blog? Contact us to get your article about ApexSQL Refactor listed here!
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
I'm a user of ApexSQL Refactor and I find it a really wonderful product.
Software Developer Consultant
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! :)
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 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!
ApexSQL Refactor is included in ApexSQL Developer
11 ApexSQL developer tools
1 year free support and upgrades
New products added for free
Combined 60% savings
For only more
Free SQL tools
SQL Azure tools
SQL solution center
Toll free +1 866 665 5500
Copyright © 2015 ApexSQL LLC