Previous Next

dbForge SQL Complete Features Overview

dbForge SQL Complete provides a wide range of code completion features that relieve users from remembering long and complex object names, column names, SQL operators, etc., but instead allows concentrating on writing high-quality SQL code with proper formatting that is easy to understand and interpret. In this page you will find a comprehensive list of features available in dbForge SQL Complete. For a list of new features see What's New in v5.5.

Smart Code Completion

context-based code completion

Context-based code completion

SQL Complete analyzes the context of the code you are typing and displays embedded T-SQL prompts, such as keywords, object names, and whole code phrases.

context-based sorting

Context-based sorting

As you type, the list of suggested relative keywords and objects is filtered based on the typed symbols, including white spaces, CamelCase, and square brackets.

automatic alias generation

Managing Aliases

When you write the FROM statement, aliases are generated automatically for database objects. What is more, you can create your own custom aliases and assign them to the objects you constantly use.

code completion for common table expressions

Code completion for CTE

SQL Complete helps you improve readability and simplify maintenance of complex queries with code completion for Common Table Expressions (CTE).

SQL Refactoring

renaming database objects

Renaming Objects

Change the names of tables, columns, views, stored procedures, and functions for names that better reveal their purpose. SCL Complete will automatically correct all references to a renamed object.

renaming SQL variables

Renaming Variables

Rename local and SQLCMD variables in a couple of seconds using the Rename functionality. Preview code changes in a convenient tree-view of the Rename dialog window.

Inserting Code Fragments

SQL statement expansion

Statement Expansion

INSERT, UPDATE, ALTER, and EXEC statements will be expanded to a full code template on pressing the Tab key to avoid tedious typing. Along with the template, the type of column data will be generated in the comments.

column list expansion

Column List Expansion

You can replace the wildcard ("*") symbol with a list of columns from a required table or view by pressing the Tab key.

SQL snippets

SQL Snippets

A SQL snippet is a frequently used code template which can be inserted into a code you are typing by pressing the Tab key. In Snippets Manager, you can modify the predefined code templates and add new ones.

column picker

Column Picker

In the SQL Complete prompt list you can check the requested columns and they will be added to your SQL document.

Code Formatting

SQL Formatter

SQL Formatter

SQL Formatter can work either with available code or the code that is being typed. Try SQL Formatter online without having to download or install anything!

SQL formatting profiles

Formatting Profiles

Create and add new formatting profiles or customize the existing ones to introduce unified code formatting standards for your company, be it a large enterprise or a small project team.

Learn more

Statement Suggestion

Suggestions for T-SQL statements

Suggestions for T-SQL statements

Smart prompts for: local and cursor variables, table definitions in DECLARE statements; cursors in OPEN, CLOSE and DEALLOCATE statements, and many others.

Suggestions for security statements

Suggestions for security statements

If you want to grant privileges to users, SQL Complete provides a list of users and roles available in the database.

Suggestions for DDL statements

Suggestions for DDL statements

SQL Complete accelerates your writing of SQL code by offering a list of DDL statements to be inserted based on the context of what you type in the SQL editor.

Suggestions for JOIN statements

Suggestions for JOIN statements

SQL Complete suggests a full JOIN statement based on foreign keys, or it can prompt conditions based on column names.

Other Features

SQL Code highlighting

Code Highlighting

The pair highlighting feature marks both the opening and closing code delimiter elements to visually define separate code blocks and determine mismatched or misspelled paired code elements, if any.

Quick object information

Quick Object Information

The application gives you essential information on tables, procedures, and other database objects while you are writing a code. When you type call statements, information on stored procedures and function parameters is displayed.

SQL code navigation

Code Navigation

With the Go to definition option, you can quickly locate a needed object in the Object Explorer tree. Document outline window allows navigating through the structure of the current SQL document which can be easily synchronized with the code.

IntelliSense for Linked servers

IntelliSense for Linked Servers

If you are using a linked server configuration, you can also use IntelliSense when creating queries. SQL Complete supports IntelliSense for a linked SQL Server.