dbForge SQL Complete is an IntelliSense add-in for SQL Server Management Studio. It offers autocompletion and formatting features for T-SQL code. The tool supports SQL Server 2000, 2005, 2008, 2012, 2014, 2016, 2019 SQL Azure and SQL Server
Version: 6.5dbForge SQL Complete is a useful add-in for SQL Server Management Studio and Visual Studio.
License: Free To Try $199.95
Operating System: Windows
Homepage: www.devart.com
Developed by:
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:
SQL Code Completion - Enhance code accuracy and quality, as well as simplify the process of creating SQL queries with the following features:
- Context-based code completion
- Code completion for CTE
- Managing aliases
- Suggestions of objects
- Code refactoring
- SQL snippets
- Statement suggestion
- Code highlighting
- Table names autocomplete
T-SQL Refactoring - This feature allows you to improve code readability by giving meaningful and self-explaining names to tables, columns, temporary tables and columns, views, stored procedures, and functions. SQL Complete will automatically correct all references to the renamed objects.- Renaming objects - Renaming variables - Finding invalid objects
Productivity - Boost your productivity when creating, refactoring, modifying, and beautifying the code using a rich set of features:
- Data Grid commands
- Grid Aggregates
- Jump between queries
- Tab Coloring
- Jump between COLUMNS and VALUES in INSERT statement
- Execution warnings
- Execution notifications
SQL Code Formatting - Create new formatting profiles or customize the existing ones to your needs.
Fine-tune your formatting style to easily improve code readability and to introduce unified code formatting standards within your company.- Formatting profiles - Formatting settings - Formatting in files and directories - Disabling formatting for a certain part of the code - Bulk formatting
Version 6.5: * Full support for SQL Server 2019 * SQL Complete Standard Edition is introduced * Temporary tables suggestion is introduced * OPENJSON objects suggestion is introduced * SSMS v18.5 integration is added
Version 6.4: * Code Debugger * Copying results from the Aggregate Panel * Modified HELP for Command Line
Version 6.3: * New formatting profiles added (Collapsed, Commas before, Indented, Right aligned, Compact, Extended, and MSDN SQL)
Version 6.1: *Visual Studio 2019 Support *SQL Format Command Line *Summary Panel Visibility
Version 5.9: *Connectivity feature (Active Directory - Universal with MFA support) *Code Completion features (New statement suggestions) *Fresh Code Refactoring feature *Productivity features (Results Grid Data Visualizers, Shortcuts to SSMS grid popup menu assigned, etc.) *Many other updates
Version 5.8: New productivity features have been implemented such as Result Grid Aggregates, Find in Results Grid, Execution warnings, CRUD generator, and much more.