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



Only for V.I.P