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 in query results grid

Features

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’s 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 the 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 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

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

See next feature

Customizable shortcuts

Define custom keyboard shortcuts for commands

See next feature

What’s new in ApexSQL Complete 2017

This article shows what new features and enhancements have been added in the new version of ApexSQL Complete 2017

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

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 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

See more
ApexSQL Redgate®
SQL Server editions
      Express
      Standard
      Enterprise
Cloud
      Azure
Integration
      SQL Server Management Studio
      Visual Studio
Features
      Code structure viewer
      Locating objects
      Object definition
      Object description
      Snippets
      SQL code auto complete
      Tab navigation
      Tab coloring
      Tooltips
      Code auto-replacements
      Copy query result as
      Executed queries
      Go to object
      Test mode
      Result search
Price
Free $369

ApexSQL Complete 2017.04

Redgate® SQL Prompt 7.3


Comparison was conducted on December 26, 2016

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

Roadmap

Azure SQL Database V12 full support

Automatically complete keywords, statements, and identifiers in Azure V12

Hints filtering

Filter hints by frequency of usage or with hints numbering

Global aliases on server level

Define and use aliases regardless of the database you are connected on

See our entire roadmap

The roadmap does not show maint only releases


ApexSQL Complete 2016 R3 Released ApexSQL Complete 2017 R1 Released ApexSQL Complete 2017 R3 Released ApexSQL Complete 2017 R4 Released ApexSQL Complete 2017 R6 Q2 ApexSQL Complete 2017 R7 Q2
Executed queries
Save query as file
Delete history option
Archive executed queries after specified number of executed queries
Presentation
Themes
Hints
Alias linked server hints support
Global aliases on server level
Multiple server hints
Object caching
Exclude connection for specific database
Save database cache locally
Tab navigation
Resume work
Close unmodified tabs
Tabs coloring
Result grid
Copy result grid data as INSERT INTO
Copy result grid data as IN clause
Search result grid
Export result grid data to Excel
Snippets
Snippet variables
Code template variables
"Nested" snippet
Clipboard snippet
Misc
SQL Server 2016 support
SQL Server Management Studio 2016 integration
Visual Studio 2015 integration
Visual Studio 2017 RC integration
SQL Server vNext CTP1 support
SQL Server Management Studio v17.0 RC1 integration
Azure SQL Database V12
SQL Server on Amazon RDS support
ApexSQL Complete 2016 R3 Released ApexSQL Complete 2017 R1 Released ApexSQL Complete 2017 R3 Released ApexSQL Complete 2017 R4 Released ApexSQL Complete 2017 R6 Q2 ApexSQL Complete 2017 R7 Q2

Testimonials

ApexSQL Complete was everything I expected and works pretty well.

Daniel Silveira

daniel.silveira@e-deploy.com.br

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

PDP.com

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

Sharky

See all of our other
Killer free tools

Decryption

Decrypt SQL Server database objects

Formatting

SQL format and refactor

Script execution

Execute scripts on multiple databases

Search

Search SQL Server data and objects