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

ApexSQL Bundles

Learn more

	ApexSQL Refactor is included in
	ApexSQL Developer Studio All 13 ApexSQL Developer tools 1 year free support and upgrades

Related products

	ApexSQL Complete Auto-complete and coding productivity features
	ApexSQL Version Database version control integration

Give it a try!

Resources

Version: 2011.01

	Videos		Knowledgebase
	FAQs		Troubleshooting
	News		Release notes
	Documentation		System requirements

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

Products	Download	Purchase	Support	News	Company
Value bundles	Installer	PDF price list	Support center	Blog	Why ApexSQL?
Database administration	Pre-releases	License	Support forum	What's new	Jobs
SQL development	System requirements	Resellers	Support FAQs	What's next	Gear
Add-ins	Version information	Competitive upgrades	Troubleshooting	Press releases	Contact us
Programmable APIs			Knowledgebase	Product updates
All ApexSQL tools			Documentation
			Product videos

Transform your code

Powerfully. Effortlessly

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

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