ApexSQL Complete 2017 – Screen shot tour

Main menu of ApexSQL Complete

ApexSQL Complete toolbar:

Options:

General

The automatic tab renaming option automatically names SQL query window based on their contents. This option searches for create, alter, insert, update, delete, exec, or truncate SQL statement in the SQL query and renames the SQL query tab using these key words, allowing you to more easily locate the window you are looking for.

The Display object tooltip after check box, displays a detailed description of each database identifier used in the SQL statement that is currently being edited, while hovering over the identifiers themselves

Here you can set when the hint-list will be shown, how objects in the hint-list will be sorted and how many items will be shown in the hint-list at once:

Inserts

To automatically insert the appropriate closing character, use the Closing characters section. ApexSQL Complete will add automatically created aliases to SQL tables and views if the Auto-generate aliases option is selected:

>

Hints

Here you can be specified which objects will be shown in the hint-list:

Aliases

Specify aliases for SQL Server objects on a server or database level. Aliases can be defined for all databases on all SQL Servers, all databases on a specific SQL Server, or just for a specific database:

Schema cache

The Schema cache is a list of objects that the add-in cached in order to show them in the hint list:

Snippets

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

Shortcuts

Define custom keyboard shortcuts for commands:

Executed queries

With this feature user, can manage executed queries, search its content and re-use them:

Log information about executed queries:

Tab navigation

With Tab navigation user, can organize and save opened tabs, explore closed tabs and re-use them:

Keep track of opened and recently closed tabs:

Tab coloring

This feature will colorize query tabs by server or database connection.

Edit existing or set a new environment:

View the object’s definition and description inline:

Code structure

Identify the structure of complex SQL queries at a glance

Auto-replacement

The Auto-replacement feature allows you to replace any text previously specified with the appropriate keyword:

Go to object

To perform a quick object search over a database in order to find SQL Server database objects and get the appropriate information (e.g. how many tables have the same name in the database with different schemas) or to locate objects in the Object Explorer pane in SSMS, the Go to object feature can be very useful:

Copy results as

The Copy query as XML, CSV, and HTML option allows users to copy the results from the SSMS results grid and paste it into one of three mentioned formats. With the Copy result as Insert statement option, a user can copy data from Results grid into clipboard as INSERT statements for the future use. Copy result as an In clause you can copy data from one or more fields in the column into the clipboard as IN clause:

Results search

This feature searches through the data in the Results grid. All found data in the Results grid will be highlighted:

April 3, 2017
  • Ricardo Leka Roveri

    Hi, I love the Complete, but it´s possible add a cosmetic feature like a dark theme?

    • Marko

      Hi Ricardo,

      Yes, we have in plan to add a dark theme (GUI themes) in ApexSQL Complete R6, which will be released in May-June 2017.

      More information can be found here: https://www.apexsql.com/whats_next.aspx