ApexSQL Refactor v.2014.06


ApexSQL Refactor is a free SQL formatter and database refactoring tool for SQL Server. Format SQL queries, refactor SQL code and database tables with ease. It can format and refactor code directly in SSMS or MSVS, qualify objects, expand wildcards, encapsulate SQL, locate and highlight unused variables and parameters, and much more for FREE.


- Support for all SQL Server and Visual Studio versions

- Split table: Improve your database design and make large tables more manageable by partitioning them

- Advanced SQL formatting: Create custom formatting profiles and share them across your team

- Customizable options: Layout your SQL code with over 160 customizable options and preview the impact of the changes

- 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

SQL Server formatting and refactoring tool. ApexSQL Refactor is a free SQL formatter and database refactoring tool for SQL Server. Format SQL queries, refactor SQL code, database tables. It expands wildcard, fully qualifies object names, renames SQL database objects ...

format sql, sql formatter, sql server, refactor sql, encapsulate sql code, database tools, sql code formatting, database software, refactoring sql code, sql query formatting, format sql query, sql refactor, format sql code

  • ApexSQL Refactor
  • 2014.06
  • 16 Jun 15
  • ApexSQL Tools
  • Win7 x32, Win7 x64, WinServer, WinVista, WinVista x64
  • Freeware
  • 5 Mb
  • 554
  • Free
Latest Versions History
Version Date Released Release Notes
2014.06 16.06.2015 Medium feature, minor fix release
2014.03 31.10.2014 Major feature, major fix release
2014.02 13.08.2014 Medium feature, medium fix release
2013.04 19.11.2013 Major feature, medium fix release

Review ApexSQL Refactor

  • captcha

Other software of ApexSQL Tools
  • ApexSQL Audit  v.2014.05ApexSQL Audit is a powerful SQL Server auditing and compliance solution with a wide range of possibilities for auditing access, changes, and security on SQL Server instances, databases, and objects ...
  • ApexSQL Build  v.2015.01ApexSQL Build-builds or updates existing SQL Server databases, creates deployment SQL scripts, C# projects and packages. It creates deployment scripts, projects and packages from SQL scripts, script folders, snapshots, or directly from source control ...
  • ApexSQL Clean  v.2014.03ApexSQL Clean analyzes SQL Server database objects, dependencies within the database, across databases, scripts and even applications. It recognizes all database dependencies, even those not recognized by SQL Server itself.

New Databases & Networks software
  • DbForge Studio for PostgreSQL  v.1.0dbForge Studio for PostgreSQL is a GUI tool for managing and developing databases and objects.
  • ApexSQL Doc  v.2015.03ApexSQL Doc documents SQL Servers, databases, objects, and SSIS packages in a single document. Create database documentation in CHM, HTML, PDF, DOC or DOCX formats. SQL Server 2014 and Azure support.
  • ATunes Pro  v.2.1.01aTunes Pro is a complete program specially developed for playing and managing all your music and videos on the computer. You can also manage and sync any external audio/video device as if you were using an iPod.