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.

Managing Aliases

When you write the FROM statement, SQL Complete automatically generates aliases for tables, views, table-valued functions, and synonyms. You can set up custom rules for assigning aliases to table objects. What is more, you can create your own custom aliases and assign them to the objects you constantly use.

SQL Complete offers a number of alias masks for managing custom alias mapping. You can use the alias masks to specify conditions and actions when assigning aliases.

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.

With the help of the rename functionally, 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.

Code Formatting

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.

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.