You'll receive

Bi-weekly updates

Exclusive discounts

Product update alerts

Automatically complete SQL statements
Review an object's script and description
Improve productivity with snippets
Identify the structure of complex SQL queries
Keep track of all your tabs
Log every executed query
Easily navigate to SQL objects
Check queries in test mode
Color query tabs by environment
Search and export query results
Create CRUD procedures
Guard against queries that may damage data


SQL code auto complete

Automatically fill in SQL keywords and names. Learn more

See next feature

Auto-complete pick list

Complete SQL fragments, such as JOIN statements or cross-database queries, in a single click. Learn more

See next feature

Qualified object names

Automatically insert fully qualified object names

See next feature

Object definition

View the object definition and description inline

See next feature

Transparent decryption

Seamlessly work with encrypted objects

See next feature

Tooltips for identifiers

View detailed information on SQL identifiers inline. Learn more

See next feature

Pair highlighting

Determine whether SQL code is formed correctly by highlighting paired elements

See next feature

Closing character auto-insertion

Ensure the number of closing and opening characters match with automatic closing character insertion

See next feature

Automatic bracketing

Improve SQL identifier visibility by automatic bracketing

See next feature

Keyword formatting

Format auto-completed keywords in UPPER, lower or Proper case

See next feature

Go to object

Find an object and highlight it inside the object explorer. Learn more

See next feature

Test mode

Execute queries safely without affecting a database. Learn more

See next feature

Results search

Search data in one or more results grids and highlight the results. Learn more

See next feature

Customizable snippets

Reuse SQL code fragments as snippets and insert context-specific values as needed. Learn more

See next feature

Snippet editing

Edit existing snippets or create your own. Learn more

See next feature

Global aliases

Specify aliases for SQL Server objects on a the server or database level. Learn more

See next feature

Tab navigation

Keep track of opened and recently closed tabs. Learn more

See next feature

Tab coloring

Colorize query tabs to create custom environments by SQL Server or database connection. Learn more

See next feature

Executed queries

Log information about executed queries. Learn more

See next feature

Code structure viewer

Identify the structure of complex SQL queries at a glance. Learn more

See next feature

Copy results as

Copy all/selected cells from query execution results to clipboard as CSV, HTML, or XML. Learn more

See next feature

Customizable shortcuts

Define custom keyboard shortcuts for commands

See next feature

CRUD procedures

Automatically create select, insert, update and delete stored procedures from the Object Explorer context menu. Learn more

See next feature

Execution alerts

Guard against accidental data damage or loss with Execution alerts. Learn more

See next feature

Export to Excel

Easily export data from the Results grid directly to Excel. Learn more

See next feature

ApexSQL Complete 2018 – Screen shot tour

This article represents a screen shot tour of ApexSQL Complete features with a brief description

How to export SQL Server data to a CSV file

This article will explain different ways of exporting data from SQL Server to the CSV file

Retrieve unsaved SQL query scripts due to SQL Server Management Studio crash

This article describes how to use the Tab navigation option from ApexSQL Complete, to retrieve unsaved SQL query scripts/files

How to prevent accidental data loss from executing a query in SQL Server aka “Practicing safe coding”

This article describes how to prevent accidental data loss from executing a query in SQL Server

Automatically creating SQL Server CRUD procedures

This video shows how to automatically create SQL Server CRUD procedures with ApexSQL Complete

How to Import and Export SQL Server data to an Excel file

This article explains how to export SQL Server data to an Excel file using the SQL Server Import and Export Wizard, T-SQL code, and ApexSQL Complete and how to import SQL Server data into Excel using the Data Connection Wizard

How to create and use CRUD stored procedures in SQL Server

This article describes how to create CRUD stored procedures via SQL Server Management Studio, Visual Studio, and ApexSQL Complete

How to code faster with SQL Server code snippets

This article describes how to use ApexSQL Complete to significantly speed up the SQL coding process and avoid typing errors

How to track executed SQL Server queries

This article introduces a feature in ApexSQL Complete that keeps track of executed queries

How to use SQL code text auto-replacements

This article describes how to use the text auto-replacement feature in ApexSQL Complete

How to improve SQL code layout and presentation

This article describes how to improve T-SQL code layout and presentation using various features and options in ApexSQL Complete

How to preview SQL Server code structure and control flow

This article introduces the Code structure feature in Apex SQL Complete

Code completion

This article describes how to use ApexSQL Complete options to manage the auto-complete hint-list and use the auto-complete feature to speed up coding

See more
ApexSQL Redgate®
SQL Server version
      SQL Server 2000
      SQL Server 2005 - 2017
      SQL Server 2019 CTP 2.0
SQL Server editions
      Azure SQL Database
      SQL Server on Amazon RDS
      SQL Server Management Studio 2012 - 17
      SQL Server Management Studio 18
      Visual Studio
      Alter object scripting
      Code structure viewer
      Copy query result as
      Current statement execution 2019
      Execution alerts
      Export result grid data to Excel
      Locating objects
      Object definition
      Object description
      SQL code auto completion
      Tab navigation
      Tab coloring
      Code investigation
      Automatic tab renaming
      CRUD procedures
      Executed queries
      Go to object
      Results search
      SQL code auto-replacements
      Test mode
      Toolbar support
      GUI themes
      High DPI and 4K resolution support
      Host aware theme adoption
      Microsoft standard iconography, colors and other visual effects
Free $365

ApexSQL Complete 2018.06

Redgate® SQL Prompt

Comparison was conducted on October 08, 2018

Redgate® SQL Prompt also includes Refactor. For a comparison of this functionality set click here

Disclaimer: All product and company names are trademarks or registered® trademarks of their respective holders.
ApexSQL is not affiliated, associated, authorized, endorsed by, or in any way officially connected with other companies listed or any of their subsidiaries or affiliates


ApexSQL Complete was everything I expected and works pretty well.

Daniel Silveira

I used ApexSQL Complete and ApexSQL Refactor. Both are well designed and include all the modern feature compare to other competitors. I found tons of customization options that makes your tools powerful.

Mohammad Sanati

Software & Database developer

I just created account on Your site and minutes later I had ApexSQL Complete and Refactor installed. I must say I was amazed what those apps can do and that they are free. Thanks for whole team for creating such amazing software and for releasing it for free. You guys are amazing!

Tomasz Jagusz

I have grown to depend on ApexSQL Complete as an essential component of my developer toolkit. It helps write better code faster.

Reuben Anderson

Data Solutions Architect

Freshfields Bruckhaus Derringer LLP

I found your product to be the best one I've used. ApexSQL Complete allowed me to write T-SQL code much faster.

Raymond Human

Human Touch Technology/Developer

Other free tools


Script, file and folder comparison

Learn more


Database object decryption

Learn more


SQL Server instance discovery

Learn more


SQL formatting and refactors

Learn more

Plan analysis

Query execution plan analysis

Learn more


Multi-database script execution

Learn more


SQL text and object search

Learn more

Database lifecycle management (DLM)

SQL Server continuous integration (CI) and delivery (CD)

Learn more