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.

    • Windows
    ...
    ApexSQL Refactor info, screenshots & reviewsAlternatives to ApexSQL Refactor

    What is ApexSQL Refactor?

    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
    Show full description ▾
    ApexSQL Refactor

    Summary and Relevance

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

    • Developed by ApexSQL
    • Proprietary and Commercial product.
    • One time purchase (perpetual license) that cost about $399.
    • 3 alternatives listed

    Popular alternatives

    View all
    ApexSQL Refactor was added to AlternativeTo by JoelCuff on May 27, 2017 and this page was last updated May 7, 2021.

    Features Vote on or suggest new features

    Comments and Reviews Post a comment / review
     all • positive • negative      relevance • date

    No comments or reviews, maybe you want to be first?

    Categories

    No category, edit the app to suggest tags that will place this app in a category

    Tags

    • format-sql-query
    • format-sql-code
    • refactor-sql
    • database-tools
    • sql-formatter
    • sql-code-formatting
    • sql-server
    ApexSQL Refactor

    Links and Download

     Official Website

    Social

    Recent user activities on ApexSQL Refactor