ApexSQL Refactor - Format and refactor SQL code. Free 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 and database tables with ease. It can format and refactor code directly in SSMS or VS, qualify objects, expand wildcards, encapsulate SQL, locate and highlight unused variables and parameters, and much more for FREE.
Features:
- SQL Server 2012 support: Format and refactor your code directly in SQL Server 2012 Management Studio. Refactor SQL Server 2012 objects including FileTables
- Support for all Visual Studio versions: Format and refactor SQL code in Visual Studio 2012, 2010, 2008 and 2005
- 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
What's New: Major feature, medium fix release

ApexSQL Refactor 2013.01 is 100% clean
This download (ApexSQLRefactor.exe) was tested thoroughly and was found 100% clean. Click "Report Spyware" link on the top if you found this software contains any form of malware, including but not limited to: spyware, viruses, trojans and backdoors.

 

1. ApexSQL Audit 2013.01 - Audit SQL Server database data changes and undo transactions.
2. ApexSQL Script 2011.02 - Script SQL Server databases and package SQL database objects and data.
3. Apex SQL Enforce 2008.04 - Enforce the Industry's SQL Server Database Standards as well as your own!
4. Apex SQL Clean 2011.01 - Apex SQL Clean - risk free delete, impact analysis and visual dependency viewer
5. Apex SQL Code 2008.05 - Apex SQL Code is a Rapid Application Development (RAD) Code Generation tool
6. ApexSQL Diff 2013.01 - Apex SQL Diff is database comparison and synchronization tool for SQL server
7. ApexSQL Doc 2013.02 - ApexSQL Doc documents SQL Server databases into CHM, HTML, HXS, Doc(x) formats
8. Apex SQL Edit 2011.02 - Apex SQL edit is an integrated SQL database editing tool/IDE
9. ApexSQL Log 2013.01 - SQL Server auditing and recovery tool. Read transaction log and undo commands.
10. Apex SQL Diff API 2011.02 - API to use ApexSQL Diff's comparison and synchronization engine.