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
  • 566
  • 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 Documenter for Oracle  v.1.0dbForge Documenter for Oracle is a handy Oracle documentation tool that automatically generates documentation of an entire Oracle database in HTML, PDF, and MARKDOWN file formats.
  • DbForge Compare Bundle for Oracle  v.4.0Oracle Compare Bundle contains two separate tools, dbForge Schema Compare for Oracle and dbForge Data Compare for Oracle to compare, analyze, synchronize Oracle databases.
  • DbForge Data Generator for Oracle  v.2.0Oracle data generator with extensive collection of basic and meaningful generators for various data types, flexible customization options, templates for creating your own generators, that delivers flawless test data generation in a well-designed UI ...
  • DbForge Data Compare for Oracle  v.5.0dbForge Data Compare for Oracle is a powerful, fast, and easy tool for comparing and synchronizing Oracle databases. It helps you quickly compare data in tables, find the differences at a glance, and generate script to effortlessly synchronize data.
  • 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.