- DbForge SQL Complete
-
dbForge SQL Complete Developer(s) Devart Stable release 3.00 / 07/14/2011 Development status Active Written in C# Operating system Microsoft Windows Size 7.86MB Available in English Type RDBMS License Commercial and Non-commercial Website http://www.devart.com/dbforge/sql/sqlcomplete dbForge SQL Complete is an add-in for SQL Server Management Studio 2005, 2008, and 2011, and Visual Studio 2008 and 2010 created by Devart that offers autocompletion and formatting of T-SQL code. The main goal of the product is to enhance basic Microsoft IntelliSense functionality.
Contents
Editions (licenses)
dbForge SQL Complete has two editions: Express and Standard.
Express is a free software, which provides basic SQL formatting and autocompletion functionality;
Standard includes much more features related to SQL formatting and autocompletion (including support of JOIN and SELECT statements, etc.). dbForge SQL Complete Standard Edition is a shareware with free 30-day trial.
History
The first version was released on 22 November 2010. It had only one, free, edition, which functionality was similar to Express Edition in version 2.0. The release of version 2.0 introduced a bunch of new features that are available in Standard Edition only.
On 14 July 2011 SQL Complete 3.0 was released. In this release both Express and Standard editions were heavily updated.
dbForge SQL Complete release news, Devart
Functionality
Main features of dbForge SQL Complete, v3.0 (Standard Edition) include:
- SQL Server support: support of SQL Server 2000, 2005, 2008, 2011 and SQL Azure, SQL Server Compact Edition;
- Visual Studio support: support of Microsoft Visual Studio 2008 (Professional and Team System editions), 2010 (Professional, Premium, Ultimate editions)
- List members for major objects: database, schema, table, view, procedure, user and table-valued function (including CLR), built-in function;
- List members for advanced objects: synonym, CLR aggregate, collation, type, XML schema collection, language;
- Smart filtering in the suggestion list;
- Parameter information for user-defined and built-in procedures/functions;
- Customizable SQL formatting;
- Quick object information for tables, procedures, asterisk in the SELECT list, alias in the FROM list, columns, dropdown list items;
- Context-sensitive suggestion of keywords;
- Sorting suggested keywords by relevance;
- Determining a database context;
- Word autocomplete;
- Asterisk expansion (in SELECT statements);
- Expanding INSERT, ALTER, and EXEC statements;
- Suggesting JOIN expressions and conditions;
- "Go to definition" for database objects;
- Code snippets for recurrent using of code fragments;
- Document Outline window;
- Highlight occurrences of an identifier;
- Execute current statement;
- Qualifying a column name on completion (in SELECT statements);
- Auto-generation of table aliases (in SELECT statements);
- Context-sensitive suggestions of DML statements: INSERT, UPDATE and DELETE;
- Context-sensitive suggestions of T-SQL statements in procedures and functions;
- Context-sensitive suggestions of CREATE TABLE, CREATE VIEW, EXEC, PRINT, TRUNCATE;
- Manual refreshing of the suggestion list;
Current version
The latest version of dbForge SQL Complete is 3.0.
See also
- Devart (company)
- IntelliSense
References
External links
Categories:- 2011 software
- SQL
- Database administration tools
Wikimedia Foundation. 2010.
