SQL Complete - Advanced Intellisense in SQL Server Management Studio

Intellisense in SQL Server Management Studio

SQL Complete: smart autocomplete for SQL Server developers & DBAs

dbForge SQL Complete is a useful add-in for SQL Server Management Studio and Visual Studio. Free and advanced paid editions of the tool offer powerful autocompletion and formatting of T-SQL code that replaces native Microsoft T-SQL Intellisense.

View Tutorial »

Key Features

Code completion

Code Completion

Code completion in SQL Complete predicts not only keywords and object names, but also whole code fragments to simplify and accelerate your work. Intelligent suggestions with smart filtering make the code typing process really smooth and fast.

View Screenshot

Statement expansion

Statement expansion

INSERT, ALTER, and EXEC statements will be expanded to the full code template on pressing the Tab key to avoid tedious typing.

Except the template, the type of column data will be generated in the comments.

View feature in action

SQL snippets

SQL Snippets

For frequent repetitive usage of code fragments, SQL snippets feature can be used. The application shows available code templates in the dropdown prompt list, and any of them can be inserted into the code you are typing on pressing Tab. In Snippets Manager, predefined templates can be modified and new ones can be added.

View feature in action

SQL Formatter

SQL Formatter

SQL code can be automatically formatted using SQL Complete. The formatter can work either with available code or the code that is being typed. You don't need to pay that much attention to case, line breaks, whitespaces, indenting, wrapping, etc - the application will take care of them all for you.

View screenshot

Quick object information

Quick object information

The application gives you essential information on database objects while you are writing code. Get such information for tables, procedures, and other objects.

Parameter information prompts you with stored procedure and function parameters when writing call statements and relieves your memory.

Quick info screenshot | Param info screenshot

Code navigation

Code Navigation

With the Go to definition option, you can locate the needed object in the Object Explorer tree in a moment.

Document outline window, in its turn, allows navigating through large SQL documents. The window shows the structure of the current SQL document which can be easily synchronized with the code both ways.

View feature in action | View screenshot

SQL Complete vs Microsoft native T-SQL IntelliSense®

SQL Code Completion

Much faster work

SQL Complete is designed to increase productivity. Application developers and DBAs work with SQL will become much faster thanks to our tool, as it provides smart prompts basing on the code context, selected database, etc. The application takes the smallest hint to guess what you are trying to write.

SQL Code Completion

Support for all SQL Server versions

With standard tool you won't get SQL Server Management Studio IntelliSense for all versions of SQL Server. Don't think when choosing with which SQL Server to work - at least, don't mind the availability of IntelliSense for this server - SQL Complete supports all of them! Just install your server and our application - and work wonders in your SQL coding!

SQL Code Completion

Pretty code with SQL formatting

SQL Complete gives you a great opportunity to fight unintelligible poorly formatted SQL code. Set wide range of formatting options so that the code is formatted in accordance with your needs and preferences - code will be easier to read, understand, debug, and test.

dbForge SQL Complete: SQL Coding Style Standardization

Coding style standardization

Always having problems with the fact that each person in your team invents his or her own SQL standards? With SQL Complete there is a way to put an end to this chaos. Introduce and maintain corporate SQL writing standards using a special tool for exporting and importing settings.

To see the complete list of differences between SQL Complete and built-in SSMS Intellisense, read the SQL Complete - Alternative to Native Microsoft T-SQL Intellisense article.

SQL Complete Express - free SQL IntelliSense add-in for SSMS

You can use SQL Complete Express as a free add-in for SQL Server Management Studio. This edition of our SQL code completion tool provides basic functionality for autocompleting and formatting code for free.

SQL Complete for Free

It may be reasonable to use SQL Complete, if you:

  • Newbie in development
  • Enthusiast that works with non-commercial projects
  • Could not prove the necessity of spending extra amount of money from the company budget to buy the full edition
SQL Complete Free Edition

What functionality does the free edition of this SQL code completion tool provide?

  • Code completion for SELECT, INSERT, UPDATE, EXEC, and DELETE statements
  • Basic SQL formatting functionality
  • Smart filtering in the suggestion list
  • Parameter information for procedures and functions

In spite of the limitations of the Express edition of our SQL autocomplete add-in, we keep an eye on the fact that it should provide more extended IntelliSense capabilities than the standard functionality.

 

What people say

 

By the way SQL Complete is one of the greatest tools I've seen for SQL Server.

Andreas Fuchs, IT Systemtechnik, Soennecken

 
 

Just thought I'd let you know that you've all done an awesome job fixing that issue - thank you all so very much. No more crashes and I have to say that I'm extremely impressed with your response times, issue resolution times and customer service - all excellent!

Well done and thank you all so much!!!

Tony Hales, Software Developer, DeMontfort Fine Art Ltd

 

More testimonials