SQL Complete is an advanced solution for SQL database development, management, and administration. Available as an add-in for Visual Studio and SSMS, the tool offers excellent autocompletion capabilities.
Version: 6.9.16SQL Complete is an advanced solution for SQL database development, management, and administration.
License: Free To Try $199.95
Operating System: Windows
Homepage: www.devart.com
Developed by:
Available as an add-in for Visual Studio and SSMS, the tool offers excellent autocompletion capabilities.
Write, beautify, refactor your SQL code easily and boost your productivity dramatically due to the features that are included in SQL Complete but are lacking in Management Studio and Visual Studio IntelliSense.
Key Features:
- Speed up SQL query writing with IntelliSense-style SQL code completion
- Beautify T-SQL code and unify code standards with smart SQL Formatter
- Get the essential information on DB objects while you are writing a code
- Format your SQL query right in Management Studio or Visual Studio
- Use rich SQL code snippet collection, manage and modify the existing snippets or create your own templates
- Navigate through the SQL document easily and synchronize it with the code
- Rename tables, columns, procedures, and functions safely with automatic correction of references to the renamed objects
- Boost your productivity significantly with convenient tabs and windows, as well as intuitive SQL statements management
You can always find the latest version of the product on the official Devart website.
Version 6.9.16: *CONSTRAINT suggestion support for ALTER TABLE statement *Suggestion of UPDATETEXT *DISTRIBUTED_AGG support for SELECT-GROUP BY *ALTER/DROP DATABASE SCOPED CREDENTIAL support *Support of Configuration Options for Query Store feature for ALTER DATABASE
Version 6.8.13: * Support for WITH INLINE for CREATE OR ALTER FUNCTION * Support of APPROX_COUNT_DISTINCT * Support of ALLOW_BATCH_MODE
Version 6.7: Improvements focused on supporting the commands that strengthen the security of sensitive data in the databases, optimizing performance, maximizing productivity, and accelerating the coding process.
Version 6.6.7: * Column sensitivity classification information is available in the completion list and quick info * The export settings for CSV file format is added * An option to tune the accuracy of decimals for Grid Aggregate is added * Export of Execution History to CSV file format
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.