Boost Productivity with SQL Complete!

With dbForge SQL Complete, users can significantly increase their productivity without making much efforts. It takes care of building, editing, and modifying SQL queries, managing and analyzing SQL code, thus making the process more efficient and as simple as ABC.

Document management

Custom SSMS main window title

Allows you to customize SSMS main window title and SQL document tabs being suitable for your requirements.

With the tool, it is possible to change the default main window title using a template. To see a list of available values, use Expression Builder on the Template field. If the project is not opened, everything in square brackets will not be displayed.

Additionally, you can modify the SQL document tab name by assigning parameters in Expression Builder of the corresponding Template field. Note: If the connection is not set for the document, everything in square brackets will not be output.

Restore last closed tab

Easily opens recently closed tabs within one SSMS session, including the unsaved ones.

The functionality monitors active open sessions, thus, allowing you to restore accidentally closed or unsaved tabs within the current IDE session.

To open recently closed tabs, right-click a tab and select Restore last closed document. Optionally, you can select Restore last closed document on the SQL Complete main menu or use shortcut keys Alt + Z.

All the matching values will be highlighted with the yellow color. Note: When you close the search bar, the highlighted result is removed.

Tab Coloring

Helps you easily define the server connection a tab is currently related to by the matching color.

With this functionality, you can simply assign a color to the environment for the servers related to development, production, sandbox or test. Additionally, it is possible to add or delete Color Match by clicking the corresponding buttons on the Settings secton of the Options menu.

Executed SQL Statements History

Stores main information about executed SQL Statements for the particular period.

With the Execution History feature, you can view, edit, and search the queries you run in the database. Additionally, you can monitor who executed a query and when, as well as other valuable information.

To open the window, click Execution History on the SQL Complete main menu. In the window that appears, you can set up the history period for the queries you are interested, as well as set a filter by size, execution date, duration, file, server, database, and user. Optionally, it is possible to edit and customize filters to your needs by clicking Edit Filter.

Data Grid commands

Generate Script As

Generates a script from SSMS grid based on the data in the table.

To open the window, right-click the required row in the Results Grid and select Generate Script As on the shortcut menu. The available statements are as follows:

  • INSERT #tmpTable
  • WHERE IN()

The result statements will be scripted to a new temporary table.

Grid Aggregates

Automatically displays calculations on the SSMS status bar after selecting two or more rows.

To calculate aggregates, select a range of values in the cells of one column in the Results Grid. On the status bar, the result of calculation operations for the following functions will be shown:

  • MAX
  • MIN
  • AVG
  • SUM

Also, note that this functionality is supported only for numeric data.

Find in Results Grid

Searches all the matching data in the grid by the specified value. To open the window, right-click somewhere in the Results Grid and select Find.

In the window, you can extend the search by adding the following search details:

  • Match Case to set a case-sensitive search
  • Whole Words to look for the single words
  • Use Regular Expressions to set the search by Reg Exp
  • Close button to close the search bar

All the data found will be highlighted in the Results Grid.

Extended menu options

Execute and view an SQL code, rename aliases and variables, generate objects to statements and scripts to a new SQL document, as well as navigate through the statements and document easily and quickly with the following features:

  • Execute current statement
  • Execute to cursor
  • Navigation from objects in SQL Doc to objects in Object Explorer
  • Jump between queries
  • Convert EXEC to Script
  • Rename Alias/Variable
  • Script object located at cursor position directly from SQL Editor
  • Script Object as ALTER/CREATE
  • Insert semicolons
Learn more
  • Jump between COLUMNS and VALUES in INSERT statement
  • Generate CRUD
  • Inline EXEC
  • Jump between BEGIN and END
  • Find invalid objects
  • Comment/Uncomment selection Coming soon
  • Copy full object name from Object Explorer Coming soon
  • Edit Top N Table Rows Coming soon
  • T-SQL Analyzer Coming soon

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