dbForge SQL Complete is a useful add-in for SQL Server Management Studio and Visual Studio. Free and paid editions of the tool offer the powerful autocompletion and formatting of T-SQL code that replaces native Microsoft T-SQL Intellisense. The tool can also be integrated into Visual Studio 2008, Visual Studio 2010, Visual Studio 2012, 2013 and 2015. Besides the extension of the List Members, Complete Word and Parameter Info features, SQL Complete also includes SQL Formatter.
Key Features: Context-based code completion; Smart filtering to suggest relative keywords and objects; Quick parameter info for functions; Customizable SQL formatting; Quick object info; Context-based sorting of suggestions in the list; Determining current database or schema; Expanding a list of columns; Suggesting conditions for JOIN statements; Expanding INSERT, ALTER, and EXEC statements; "Go to definition" for database objects; Code snippets; Document Outline window; Highlight occurrences of an identifier; Execute current statement; Automatic alias generation; Suggestions of T-SQL statements in procedures and functions; Suggestions of other SQL statements; IntelliSense for linked servers; Semi-transparent view of the suggestion box; Phrase Completion; Code Formatting for MERGE Statements.
What is new in this release:
- New SQL Server 2016 syntax supported
- SQL Complete now integrates into SSMS 2016
- Objects suggestions in CROSS/OUTER APPLY statement
- Suggestion of compound phrases
- Greatly improved suggestion performance
- Several new formatter options and profiles
- Both objects and schemas suggestions in Completion List when writing cross-database queries
What is new in version 5.1:
Version 5.1: Visual Studio 2015 support.
What is new in version 4.8:
Version 4.8: Alias refactoring; User defined table type suggestion; Tables suggestion while creating indexes; Support for new keywords introduced in SQL Server 2014.
SQL Server Management Studio/Visual Studio