Refactor your SQL code easily!

dbForge SQL Complete provides users with a rich set of tools that are aimed to help them improve the process of creating the code and building queries, thus, enhancing code quality. In addition, the tool can highlight code elements and values, thus checking, whether users correctly spelled paired elements, and much more.

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

Managing Aliases

Rename objects/variables

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 few seconds. Preview code changes in a convenient tree-view of the Rename dialog window.

SQL Refactoring

Find Invalid Objects

With this functionality, you can simply detect and fix invalid objects that often appear during database development process. Search for objects that cannot be compiled or executed just in a few clicks as well as generate effective scripts to manage them.

The functionality provides the following opportunities:

  • Searching and detecting invalid objects through multiple databases
  • Analyzing and reporting the found results
  • Managing the objects through Script as ALTER and Script as DROP buttons
  • Simple navigation through Find Invalid Objects grid

Find in Results Grid