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.
SQL Formatter online
without having to download or install anything!
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.
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.
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
SQL Complete vs Microsoft native T-SQL IntelliSense®
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.
Support for all SQL Server versions
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!
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.
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,
SQL Complete - Alternative
to Native Microsoft T-SQL Intellisense
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.
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.
Use SQL Complete, if you:
- Newbie in development
- Could not prove the necessity of spending extra amount of money from the company
budget to buy the Standard edition
- Enthusiast that works for nonprofit organizations such as universities, churches,
educational institutions, municipalities and their agencies
FREE edition provides:
- 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