dbForge SQL Complete is a useful add-in for SQL Server Management Studio and Visual Studio. Free and advanced paid editions of the tool offer powerful autocompletion and formatting of T-SQL code that replaces native Microsoft T-SQL Intellisense. Key features: * Name suggestions for all SQL Server objects * Smart filtering in the suggestion list * Context-sensitive suggestion of keywords * Database context detection * Context-sensitive object suggestions for SELECT DML DROP EXEC SET and USE statements * Parameter information for functions * Quick object information in a pop-up window * Customizable SQL formatting * Execute current statement in a script * Semi-transparent view of the suggestion box * Name suggestions for objects on linked servers * Column picker for quick list building * JOIN clause auto generation * Wildcard expansion * INSERT EXEC and ALTER statements expansion * Auto-generation of table aliases * Code completion for common table expressions (CTE) * Context-sensitive object suggestions for T-SQL code DDL and security statements * SQL Snippets for reusable code * Document Outline window for showing script structure * "Go to definition" for database objects * Adjust keyword case on typing * Intellisense in SQLCMD mode * Highlight occurrences of an identifier * Sorting suggested keywords by relevance * Export/Import Settings Wizard Compatibility Microsoft SQL Server: * SQL Server 2012 * SQL Server 2008 2008R2 (including Express) * SQL Server 2005 (including Express) * SQL Server 2000 * SQL Azure * SQL Server Compact Microsoft SQL Server Management Studio: * SSMS 2012 * SSMS 2008 2008R2 (including Express) * SSMS 2005 (including Express) Microsoft Visual Studio: * Visual Studio 2010: Professional Premium and Ultimate editions * Visual Studio 2008: Professional and Team System editions