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.
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