SQL Complete v6.5 release notes

Last modified: April 9, 2025

  • Full support for SQL Server 2019
  • SQL Complete Standard Edition is introduced
  • Properties for built-in metadata functions (SERVERPROPERTY, FILEPROPERTY, DATABASEPROPERTYEX, etc.) suggestion
  • Temporary tables suggestion is introduced
  • OPENJSON objects suggestion is introduced
  • Support for the following functions: NEWSEQUENTIALID, CERTPRIVATEKEY, CERTENCODED, PWDENCRYPT and PWDCOMPARE
  • Support for the following SQL statements: GRANT ALTER ANY SECURITY POLICY, GRANT ALTER ANY SENSITIVITY CLASSIFICATION, GRANT ALTER ANY DATABASE SCOPED CONFIGURATION, GRANT ALTER ANY COLUMN MASTER KEY, GRANT ALTER ANY COLUMN ENCRYPTION KEY, GRANT EXECUTE ANY EXTERNAL SCRIPT, GRANT ALTER ANY EXTERNAL DATA SOURCE, GRANT ALTER ANY EXTERNAL FILE FORMAT, GRANT ALTER ANY EXTERNAL LANGUAGE, GRANT ALTER ANY EXTERNAL LIBRARY, GRANT ADMINISTER DATABASE BULK OPERATIONS
  • Expanded support for the function PREDICT for SQL Server 2019 is added
  • Expanded support for the following statements is added: CREATE USER for Azure SQL Database, CREATE INDEX for SQL Server 2019, CREATE EXTERNAL LIBRARY for SQL Server 2019, ALTER DATABASE for SQL Server 2019, ALTER TABLE for SQL server 2019, ALTER EXTERNAL LIBRARY for SQL Server 2019, ALTER AVAILABILITY GROUP for SQL server 2019, DROP EXTERNAL RESOURCE POOL for SQL Server 2019, DROP EXTERNAL LIBRARY for SQL Server 2019, ACCELERATED_DATABASE_RECOVERY in ALTER DATABASE for SQL Server 2019
  • SSMS v18.5 integration is added

Want to find out more?

Overview

Overview

Take a quick tour to learn all about the key benefits delivered by SQL Complete.

All features

All features

Get acquainted with the rich features and capabilities of the tool in less than 5 minutes.

Request a demo

Request a demo

If you consider employing this tool for your business, request a demo to see it in action.

SQL Complete logo

Ready to start using  

SQL Complete?

Download a FREE 14-day trial