SQL Complete v6.9 release notes

Last modified: April 9, 2025

• Support for CONSTRAINT suggestion in the ALTER TABLE statement
• Suggestion of UPDATETEXT
• Support for DISTRIBUTED_AGG in SELECT - GROUP BY
• Support for ALTER/DROP DATABASE SCOPED CREDENTIAL
• Support for Configuration Options for Query Store feature in ALTER DATABASE
• Support for WAIT_AT_LOW_PRIORITY in ALTER TABLE … SWITCH PARTITION
• Support for new keywords in ALTER DATABASE SCOPED CONFIGURATION
• Support for CREATE/ALTER/DROP EVENT SESSION session_name ON DATABASE (for Azure SQL)
• Support for ALTER SERVER CONFIGURATION in MEMORY_OPTIMIZED options