dbForge SQL Complete is a useful add-in for Microsoft SQL Server Management Studio and Microsoft Visual Studio. Free and advanced paid editions of the SQL code formatter offer powerful autocompletion and formatting of T-SQL code that replaces native Microsoft T-SQL Intellisense.
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
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.
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
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.
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
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 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.
With standard tool you won't get SQL Server Management Studio IntelliSense for all versions of Microsoft 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 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.
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.
You can use SQL Complete Express as a free add-in for SQL Server Management Studio. You are eligible to use SQL Complete Express either for non-commercial or commercial purposes. This edition of our SQL code completion tool provides basic functionality for autocompleting and formatting code for free.
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.
Need more than a sole tool?
Try dbForge Fusion for SQL Server
If you are an SQL Server MVP,
send us a link to your Microsoft MVP profile and get a free
licence for any SQL Server product!
Learn more about SQL Azure support in
You might be also interested in:
SQL Server management tools: