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

Version: 2017.02ApexSQL Refactor is a free SQL formatter and database refactoring tool for SQL Server. Format SQL queries, refactor SQL code and database tables with ease.
License: Free
Operating System: Windows
Homepage: www.apexsql.com
Developed by:
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.
Features:
- Support for SQL Server 2005 and above
- Support for Visual Studio 2010 and above
- 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 200 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 arent 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 2017 CTP 2 support
- SQL Server Management Studio integration
- Smart indent feature
- Batch format SQL objects feature
- Obfuscate SQL feature
- Visual Studio 2017 integration
What's New
Version 2017.02: Major feature, major fix release
Version 2016.04: Medium feature
Version 2016.01: Major feature, major fix release
Version 2014.07: Medium feature, minor fix release
Version 2014.03: Major feature, major fix release
Version 2010.05: Medium Feature, Minor Fix Release