2 Like

ApexSQL Refactor

ApexSQL Refactor is a free SQL formatter and database refactoring tool for SQL Server. Created by ApexSQL

Free
Windows

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.

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 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 2017 CTP 2 support
- SQL Server Management Studio integration
- Smart indent feature
- Batch format SQL objects feature
- Obfuscate SQL feature
- Visual Studio 2017 integration... More Info »

Links to official ApexSQL Refactor sites

Official Website Facebook Twitter

Feature

Autocompletion Add a feature

Tags

autocompletion database-tools format-sql format-sql-code format-sql-query refactor-sql sql-code-formatting sql-formatter sql-server

ApexSQL Refactor was added by JoelCuff in May 2017 and the latest update was made in May 2019. The list of alternatives was updated Jun 2017 There is a history of all activites on ApexSQL Refactor in our Activity Log. It's possible to update the information on ApexSQL Refactor or report it as discontinued, duplicated or spam.

MORE APP INFO Official website

Reviews 0

Alternatives to ApexSQL Refactor for all platforms with any license

dbForge SQL Complete

dbForge SQL Complete is an IntelliSense add-in for SQL Server Management Studio, designed to provide the fastest T-SQL query typing ever possible.

Commercial $ $ $ Windows SQL Server Management Studio Microsoft Visual Studio
Autocompletion Code completion Code formatting Add a feature

57 Like
SQL Prompt

SQL Prompt Pro strips away the repetition of coding by making writing, formatting, and refactoring SQL effortless.

Commercial Windows SQL Server Management Studio Microsoft Visual Studio
Autocompletion Intellisense Refactoring Add a feature

3 Like
Sql Assist

SQL Assistant easily integrates with many widely used database editors and database management and development environments including native tools that come with your...

Commercial Windows
Intellisense Add a feature

0 Like

Know any alternatives we haven't listed?

We want more alternatives to ApexSQL Refactor. Feel free to add any alternative that you know of, or ask your friends on Twitter or Facebook if they can help out.

ApexSQL Refactor Comments

Echo echo ... Feels empty in here

Maybe you want to be the first to submit a comment about ApexSQL Refactor? Just click the button up to your right!