X

Subscribe to our bi-weekly newsletter


Email:


   




 
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

Features

SQL code auto-complete

Automatically fill in SQL keywords and names

See next feature

Auto-complete pick list

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

See next feature

Qualified object names

Automatically insert the fully qualified object name

See next feature

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

See next feature

Pair highlighting

Determine whether the SQL code is formed correctly by highlighting paired elements

See next feature

Closing characters auto-insertion

Ensure the number of closing characters matches the number of opening ones with automatic closing character insertion

See next feature

Automatic bracketing

Improve SQL identifier visibility by bracketing them automatically

See next feature

Keyword formatting

Format auto-completed keywords in upper, lower or proper case

See next feature

Go to object form

Finds an object from database and highlights it inside the object explorer

See next feature

Test mode

Execute queries without affecting a database

See next feature

Customizable snippets

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

See next feature

Snippet editing

Save development time by creating your own snippets or editing the predefined ones

See next feature

Global aliases

Specify aliases to be filled in for objects from all SQL Server instances and database

See next feature

Tab navigation

Keep track of opened and recently closed tabs

See next feature

Executed queries

Log information about executed queries

See next feature

Code structure viewer

Identify the structure of complex SQL queries at a glance

See next feature

Copy results as

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

See next feature

Completion options

Define insertion keys and fine tune auto-complete layout and performance

See next feature

Customizable shortcuts

Define custom keyboard shortcuts for commands

See next feature

Roadmap

SQL Azure V12 full support

Automatically complete keywords, statements, and identifiers in Azure V12

Visual Studio 2015 support

Use ApexSQL Complete from within the latest version of Microsoft’s IDE

Global aliases on server level

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

See our entire roadmap

What's next for ApexSQL Complete: ApexSQL Complete 2014 R10 – maintenance version


ApexSQL Complete 2014 R8 released ApexSQL Complete 2014 R9 released ApexSQL Complete 2015 R1 Q2 ApexSQL Complete 2015 R2 Q3
Hints
Filtering hints based on context
Linked server hints
Join hints
Selection of multiple hints hints
Hint list transparency
Tooltips on hover
Auto - aliasing
From first three leters
From first leter of each word
Add AS keyword
Customizable case
Insert , update statements completion
With a key shortcut
With the usage of alias
Procedure,functions statement completion
With a key shortcut
With input parameter tooltips
Show object body on hover in the hint list
Filtering hints based on frequency of usage
Sublime text filter for hints
Hints numbering*
Global aliases on database level
Global aliases on server level
Object explorer navigation
Navigate to object from a script
"Go to object" form
Support for object types for both features
Tables
Views
Stored prodecures
Functions
DDL Triggers
Schemas
Users
XML Schema Collections
Full text catalogs
Queues
Services
Triggers
Parameters
Columns
Tab navigation
Monitor opened tabs
Monitor recently closed tabs
Search tabs by content
Reopen tabs with double click
Customizable storing interval
Customizable storing location
Save workspace and reopen it on future SSMS sessions
Snippets
Inserting from the hint list
Inserting from the context menu
Creating snippets from the context menu
Creating snippets from selection
Predefined snippets
Export\Import
Show snippet body on hover in the hint list
Snippet variables
Custom format for $DATE$ variable
Custom format for $TIME$ variable
Code template variables*
Code structure
Display summarized view of the script
Navigate to specific statements on click
Executed queries
Log executed queries
Search executed queries by content and execution date
Reopen queries with double click
Customizable maximum query size for logging
Customizable storing location
Save query as file
Delete history option
Archive after x number of queries
Misc
Copy query results as
XML
CSV
HTML
Exclude connections to specific databases
SQL Azure v12 basic support
SQL Azure v12 full support
Visual Studio 2015 support
Select top x rows for object from the script
Progress indicator for the Refresh Cache option
Change connection from Object Explorer context menu
Usability improvements. Improved quality
ApexSQL Complete 2014 R8 released ApexSQL Complete 2014 R9 released ApexSQL Complete 2015 R1 Q2 ApexSQL Complete 2015 R2 Q3

Content

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

Save a bundle

ApexSQL Complete is included in ApexSQL Developer

11 ApexSQL developer tools

Priority support

1 year free support and upgrades

New products added for free

Combined 60% savings

For only more