dbForge SQL Complete Express is a free add-in for Visual Studio and Microsoft SQL Server Management Studio (SSMS) that provides IntelliSense functionality.
dbForge SQL Complete Express is a free add-in for SQL Server Management Studio and Visual Studio. It offers powerful autocompletion and formatting of T-SQL code that replaces native Microsoft T-SQL Intellisense ®. Besides extending List Members, Complete Word and Parameter Info features, SQL Complete adds SQL Formatter.
Key Features
Smart filtering to suggest relative keywords and objects
SQL Complete filters the suggestion list based on various criteria:
first typed symbols,
a whitespace,
camel case,
a square bracket.
You can be sure, whatever you type, the suggestions will be just what you wanted.
Parameter information for functions
When you are typing names of user-defined and built-in functions and procedures, SQL Complete displays their parameter information in a hint.
Customizable SQL formatting (partial support')
Produce clear and well-formatted code without worrying about all those indents, whitespaces, wrappings, line breaks, etc. Just keep typing your SQL and see it automatically transformed based on your preferences and formatting rules. With a wide selection of formatting options you can set any formatting style you need.
Context-sensitive suggestion of keywords (partial support')
SQL Complete thoroughly defines the context to predict what you want to type next. It displays only relative keywords and names of database objects. Just type several symbols and see the required word in the suggestion list. It takes only to press Enter and go on with your query.
Determining a current database or schema
SQL Complete displays a list of database objects from the current database or schema even if their names are not specified in a query. The names of the current database or schema are determined based on connection properties of the current SQL document. Besides, SQL Complete finds USE statements in the code and changes the current database for subsequent SQL statements.
Semi-transparent view of the suggestion box
When your code is overlapped by the suggestion box, do not close the suggestion box. Hold Ctrl to make the suggestion box switch to semi-transparent view.
Execute current statement
Now user can execute the current SQL statement without selecting it. You can just place the cursor within the statement and select the needed menu item from the context menu - and SQL Complete will define statement boundaries itself.