Description

dbForge SQL Complete provides a wide range of code completion features that relieve users from memorizing long and complex object names, column names, SQL operators, etc. Instead, it allows concentrating on writing high-quality SQL code with correct formatting that is easy to understand and interpret. On this page, you will find a comprehensive list of features available in dbForge SQL Complete.

SQL Complete is an advanced solution for SQL database development, management, and administration. Available as an add-in for Visual Studio and SSMS, the tool offers excellent autocompletion capabilities. Write, beautify, refactor your SQL code easily and boost your productivity dramatically due to the features that are included in SQL Complete but are lacking in Management Studio and Visual Studio IntelliSense.

Speed up SQL query writing with IntelliSense-style SQL code completion

Beautify T-SQL code and unify code standards with a smart SQL Formatter

Get the essential information on DB objects while you are writing code

Format your SQL queries directly in SSMS or Visual Studio

Use rich SQL code snippet collection, manage and modify the existing snippets or create your own templates

Navigate through SQL documents easily and synchronize them with the code

Rename tables, columns, procedures, and functions safely with automatic correction of references to the renamed objects

Boost your productivity significantly with convenient tabs and windows, as well as intuitive management of SQL statements

SQL Code Completion

Enhance code accuracy and quality, as well as simplify the process of creating SQL queries with the following features:

Capabilities:

Context-based code completion

Code completion for CTE

Alias management

Object suggestions

Code refactoring

SQL snippets

Statement suggestions

Code highlighting

Table name autocompletion

The add-in will take care of autocompleting your SQL queries so that you can stay focused on how your code actually works.

T-SQL Refactoring

This feature allows you to improve code readability by giving meaningful and self-explaining names to tables, columns, temporary tables and columns, views, stored procedures, and functions. SQL Complete will automatically correct all references to the renamed objects.

Capabilities:

Renaming objects

Renaming variables

Finding invalid objects

You can also change the names of local and SQLCMD variables in a couple of seconds. Preview code changes in a convenient tree-view of the Rename dialog window. With the SQL Complete tool, SQL code refactoring becomes easy and seamless.

Productivity

Boost your productivity when creating, refactoring, modifying, and beautifying the code using a rich set of features:

Capabilities:

Data Grid commands

Grid aggregates

Jump between queries

Tab coloring

Jump between COLUMNS and VALUES in the INSERT statement

Execution warnings

Execution notifications

Ease of navigation, instant access to database object definitions, and other advanced options greatly facilitate the design and formatting of SQL statements.

SQL Code Formatting

Create new formatting profiles or customize the existing ones to meet your needs. Fine-tune your formatting style to easily improve code readability and introduce unified code formatting standards within your company.

Capabilities:

Formatting profiles

Formatting settings

Formatting in files and directories

Disabling formatting for a certain part of the code

Bulk formatting

With the SQL script formatter, you can work with either new or existing code. Try the online SQL Formatter without having to download or install anything!

See the differences in code before and after formatting

SQL Complete helps users create, customize, and switch between formatting styles, share them with their colleagues, as well as manage and easily format SQL scripts by applying various formatting options.

Intelligent SQL completion and suggestion

Intelligence Coding

Context-sensitive suggestion of keywords

Context-sensitive object suggestions

Context-sensitive object suggestions for T-SQL code, DDL, and security statements

Context-sensitive object suggestions for common table expressions (CTE)

Context-sensitive object suggestions in SQLCMD mode

Name suggestions for objects on linked servers

Sorting suggested keywords by relevance

JOIN clause auto generation

Disable/Enable Code Completion

Phrase completion

Semi-transparent view of the suggestion box

Auto-generation of table aliases

Custom alias mapping

Column picker for quick list building

Wildcard expansion

INSERT, EXEC, ALTER and UPDATE statements expansion

SQL snippets

Recently closed documents

Exclude databases from suggestion

Highlight occurrences of an identifier

Pair highlighting

Named regions

Highlight of matching columns in the INSERT statement

Column name in the values area for INSERT statement

Parameter information for functions

Quick object information

Rows Count information

ON condition suggestion for JOIN

Reverse ON condition suggestion for JOIN

Additional Information