Resolve

issues faster

Database Tools
Must-have SQL Server tools and tools for MySQL, Oracle, and PostgreSQL database development, management and administration
Learn more

Data Connectivity
The most trusted solutions for your data connectivity needs: ADO.NET, ODBC, SSIS, Excel, dbExpress, Delphi Components
Learn more

Productivity Tools
Write code, create reviews, compare sources, track the working hours with the web app, utilize the power of ORM Solutions
Learn more

Data Services
Data integration, online backup, web-based SQL tools, cloud connectivity solution
Learn more

SQL Complete

Editions of dbForge SQL Complete

dbForge SQL Complete comes in two editions: Express and Standard.

Express is a free edition that provides basic code completion functionality. To see advantages of dbForge SQL Complete over Microsoft SQL Server Management Studio 2017 (SSMS), please refer to the SQL Complete - Alternative to Native Microsoft T-SQL Intellisense article.

Standard edition extends the Express edition's functionality. Energize your work with a perfect intellisense tool. Buy dbForge SQL Complete Standard, and it will reward you with the fastest SQL statements writing and extra time for a cup of coffee.

The matrix below compares features of dbForge SQL Complete Express and Standard editions.

Features

Exp

Std

Name suggestions for major objects1
Yes
Yes
Screenshot
Name suggestions for advanced objects2
Partially supported
Yes
Difference
Smart filtering in the suggestion list
Yes
Yes
Screenshot
Context-sensitive suggestion of keywords
Partially supported
Yes
Difference
Database context detection
Yes
Yes
Screenshot
Context-sensitive object suggestions for SELECT, DML, DROP, EXEC, SET, and USE statements3
Yes
Yes
Screenshot
Parameter information for functions
Yes
Yes
Screenshot
Quick object information
Partially supported
Yes
Difference
SQL formatting
Partially supported
Yes
Difference
Formatting in files and directories
Yes
Yes
Screenshot
Execute current statement
Yes
Yes
Screenshot
Semi-transparent view of the suggestion box
Yes
Yes
Screenshot
Statement navigation
Yes
Yes
Demo
Enclosing needed identifiers in square brackets
No
Yes
Screenshot
Database identifier case synchronization
No
Yes
Demo
Individual word recognition in CamelCase identifiers
No
Yes
Demo
Name suggestions for objects on linked servers
No
Yes
Screenshot
Column picker for quick list building
No
Yes
Demo
JOIN clause auto generation
No
Yes
Demo
Wildcard expansion
No
Yes
Demo
INSERT, EXEC, and ALTER statements expansion
No
Yes
Demo
UPDATE statements expansion
No
Yes
Demo
Stored procedure expansion
No
Yes
Screenshot
Auto-generation of table aliases
No
Yes
Demo
Code completion for common table expressions (CTE)
No
Yes
Screenshot
Context-sensitive object suggestions for T-SQL code, DDL, and security statements3
No
Yes
Screenshot
SQL snippets
No
Yes
Demo
Document outline window 4
No
Yes
Screenshot
"Go to definition" for database objects
No
Yes
Demo
Adjust keyword case on typing
No
Yes
Demo
Disable formatting for a certain block of code (noformat tag)
No
Yes
Screenshot
Code completion in SQLCMD mode
No
Yes
Screenshot
Highlight occurrences of an identifier
No
Yes
Screenshot
Sorting suggested keywords by relevance
No
Yes
Difference
Import Export Settings Wizard
No
Yes
Screenshot
Custom alias mapping
No
Yes
Screenshot
SQL Refactoring
No
Yes
Demo
Phrase completion
No
Yes
Screenshot
Pair highlighting
No
Yes
Screenshot
Execution History
No
Yes
Screenshot
Execution warnings New!
No
Yes
Screenshot
CRUD generator New!
No
Yes
Screenshot
Run script on multiple databases New!
No
Yes
Screenshot
Execution notifications New!
No
Yes
Demo
Transaction reminder New!
No
Yes
Screenshot
Find in Results Grid New!
No
Yes
Screenshot
Grid Aggregates New!
No
Yes
Screenshot
Highlight of matching columns in the INSERT statement
No
Yes
Screenshot
Query navigation
No
Yes
Screenshot
CASE END pair highlighting
No
Yes
Screenshot
Generation of the CREATE/ALER script for server objects
No
Yes
Screenshot
Generate Script As from SSMS data grid
No
Yes
Screenshot
Semicolon insertion
No
Yes
Demo
Restore last document session
No
Yes
Demo
Custom SSMS main window title & SQL document tabs caption
No
Yes
Screenshot
Close unmodified tabs
No
Yes
Screenshot
Tab coloring
No
Yes
Screenshot
Script object as CREATE/ALTER
No
Yes
Screenshot
Excluding databases from prompts
No
Yes
Screenshot
Get Row Count
No
Yes
Screenshot
Copy Results Grid Headers (Column Names + Types)
No
Yes
Screenshot
Expanding sp_executesql
No
Yes
Screenshot
Named Regions
No
Yes
Screenshot

Single License Price

Free

$199.95


1 Major objects are database, schema, table, view, procedure, user and table-valued function (including CLR), built-in function.

2Advanced objects are synonym, CLR aggregate, collation, type, XML schema collection, language, XML and VARCHAR(MAX) data type methods.

3 To learn more about supported context read the SQL Complete Context article.

4 Document Outline window is supported for Microsoft SQL Server Management Studio 2012 or higher.