dbForge SQL Complete Express 2.50

dbForge SQL Complete Express is a free intellisense add-in for SQL Server Management Studio 2000, 2005 and 2008 that offers powerful autocompletion and formatting of T-SQL code.

Besides extending List Members, SQL Formatting, Complete Word and Parameter Info features, SQL Complete Express adds Quick Object Info that shows essential information about database objects.

Key features:

* Smart filtering:
SQL Complete filters the suggestion list based on various criteria:
- first typed symbols,
- a whitespace,
- camel case,
- a square bracket.

* Quick Object Info:
Essential information about a database object is shown in the popup window
when the mouse cursor is over the identifier.

* List members:
List members for major objects: database, schema, table, view, procedure, user and table-valued function (including CLR), built-in function, synonym, CLR aggregate;

* Parameter information for user-defined and built-in procedures/functions:
When you are typing names of user-defined and built-in functions and procedures, SQL Complete displays their parameter information in a hint.

* SQL formatting:
Produce clear and well-formatted code without worrying about all those indents, whitespaces, wrappings, line breaks, etc.

* Determining a database context:
SQL Complete displays a list of database objects from the current database or schema even if their names are not specified in a query.

* Word autocomplete;

* Context-sensitive suggestions of DML statements: INSERT, UPDATE and DELETE;

* Manual refreshing of the suggestion list.