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.0.

Smart Code Completion

context-based code completion
context-based sorting
automatic alias generation
code completion for common table expressions

Context-based code completion

SQL Complete analyzes the context of the code you are typing and displays not only relative keywords and object names, but also whole code phrases to simplify and accelerate your work.

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.

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 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 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.

renaming SQL variables

Inserting Code Fragments

SQL statement expansion
column list expansion
SQL snippets
column picker

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

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

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

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!

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.

SQL formatting profiles

Statement Suggestion

Suggestions for T-SQL statements
Suggestions for security statements
Suggestions for DDL statements
Suggestions for JOIN 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

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

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

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
Quick object information
SQL code navigation
IntelliSense for Linked servers

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

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.

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

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.