ApexSQL Refactor

Transform your code

A powerful formatting tool
      A collection of amazing code refactors

Value bundles
Refactor is included in
ApexSQL Developer Studio
  • All 13 ApexSQL developer tools
  • 1 year free support and upgrades
Related products
Resources
Version: 2013.01
Videos Knowledgebase
FAQs Troubleshooting
News Release notes
Documentation System requirements

 Datasheet: Formatting screen mockups and examples

Performance improvements   
Visual Studio 2012 support versions  
Formatting profiles      Save and quickly toggle between different sets of formatting settings
Batch SQL scripts formatting     Format SQL scripts and script folders in batches
SQL Server 2012 support
Advanced SQL formatting   Layout your SQL code with over 160 customizable options and preview the impact of the changes
Customizable options    Create custom formatting profiles and share them 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 table names and schema 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 code by identifying and removing parameters and variables that aren’t used
Replace one-to-many relationships  Add a 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
Split table   Improve your database design and make large tables more manageable by partitioning them
Support for all Visual Studio versions
Support for all SQL Server versions
Products Download Purchase Support News Company
Database administration Installer License Support forum What's new Why ApexSQL?
SQL development Patches Resellers Knowledgebase What's next Jobs
Productivity add-ins System requirements Competitive upgrades Documentation Press releases Gear
Programmable APIs Version information   Product videos Product updates Contact us

© 2013 ApexSQL LLC | +1 (866) 665-5500