ApexSQL Refactor icon
ApexSQL Refactor icon

ApexSQL Refactor

ApexSQL Refactor is a 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.

ApexSQL Refactor screenshot 1

Cost / License

  • Pay once
  • Proprietary

Platforms

  • Windows
ApexSQL Refactor screenshot 1
ApexSQL Refactor screenshot 2
+3
ApexSQL Refactor screenshot 3
Alternatives  
2likes
3alternatives
0articles

Features

ApexSQL Refactor News & Activities

Highlights All activities

Recent activities

No activities found.

ApexSQL Refactor information

Our users have written 1 comments and reviews about ApexSQL Refactor, and it has gotten 2 likes

ApexSQL Refactor was added to AlternativeTo by JoelCuff on and this page was last updated .

Comments and Reviews

   
Guest
0

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.

This is incorrect description!!! The tool is not free since 2021...

Review from a new or low-activity account — shown here, but not counted in the app rating.

Official Links

What is ApexSQL Refactor?

ApexSQL Refactor is an 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.

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