X

Join or Sign In

Sign in to add and modify your software

Continue with email

By joining Download.com, you agree to our Terms of Use and acknowledge the data practices in our Privacy Policy.

ApexSQL Refactor

By ApexSQL Free

Developer's Description

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 2014 support: Format and refactor your code directly in SQL Server 2014 Management Studio. Refactor SQL Server 2012 objects including FileTables . Support for all Visual Studio versions: Format and refactor SQL code in Visual Studio 2013. 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.

Full Specifications

What's new in version 2014.02

General

Release September 14, 2014
Date Added September 14, 2014
Version 2014.02

Operating Systems

Operating Systems Windows 8, Windows Vista, Windows, Windows Server 2008, Windows 7
Additional Requirements MSSQL Server 2014, 2012, 2008 or 2005 with with Microsoft SQL Management Studio 2005 with SP2

Popularity

Total Downloads 807
Downloads Last Week 0
Report Software

Related Software

Microsoft Office Access 2010

Free to try
Microsoft Office Access 2010

CSV Viewer

Free
CSV Viewer

Inventory Management System for Small Business in Access Templates

Free
Inventory Management System for Small Business in Access Templates

FileMaker Pro

Free to try
FileMaker Pro