ApexSQL Refactor

Transform your code

Powerfully. Effortlessly

A powerful, feature rich formatting tool,
meets a collection of amazing code refactors

Order Pro version
from  $99  $49
Contact us for volume discounts
ApexSQL Bundles
ApexSQL Refactor is included in
  • All 13 ApexSQL Developer tools
  • 1 year free support and upgrades
Give it a try!

 Datasheet: Formatting screen mockups and examples

SQL Server 2012 support  
Advanced SQL formatting   Format your SQL with over 160 customizable options and preview the impact of changes
Customizable options   Create custom formatting profiles and share across your team
Impact analysis   Preview the impact of changes with difference highlighting
Expand wildcards   Transform * wildcards into explicit lists of column names
Qualify object names   Qualify columns with schema and table names or aliases
Copy SQL code as   Render T-SQL into its Java, C#, C++, VB .NET, PHP, Ruby, Delphi or PowerBuilder equivalent. Copy and paste it into your applications data access layer
Add surrogate key  Replace complex, multi-column primary keys with a single column surrogate key
Find unused variables and parameters  Clean up your SQL code by identifying and removing parameters and variables that aren’t used
Replace one-to-many relationship  Add new associative table to replace one-to-many relationships
Change parameters  Add, remove or change parameters without breaking dependencies from referencing objects
Encapsulate SQL  Convert blocks of SQL code into scalar or table functions, stored procedures and views. Automatically identify and create the input parameters
Smart rename  Rename tables, procedures, views, functions and columns risk-free
Support for all SQL Server versions