Released: Sep 12, 2022

Updates in V6.3.9

Features

• Microsoft SQL Server 2022 - Added support for:
  • 'ALTER DATABASE SCOPED CONFIGURATION'.
  • 'ALTER INDEX'.
  • 'ALTER TABLE'.
  • 'CREATE CLUSTERED INDEX'.
  • 'CREATE INDEX'.
  • 'CREATE TABLE'.
• Added query hints for 'DELETE', 'INSERT', 'SELECT', 'UPDATE' and 'MERGE' statements.
• Added support for 'BACKUP SYMMETRIC KEY' syntax construct.
• Added support for 'RESTORE SYMMETRIC KEY' syntax construct.
• Added support for 'DATE_BUCKET' function in Completion List, Quick Info and Parameter Information.
• Source Control improves Refresh operation performance.
• Updated query execution plan for SQL Server 2022.
• Added support for creating constraints on computed columns in Table Editor.

Fixes

• Fixed incorrect script generation for table-based types in specific environments.
• Fixed poor Data Editor and Data Viewer performance when operating huge data sets.
• Fixed a syntax error that occurred when using built-in functions.
• Fixed a bug in Table Editor that occurred when changing table options in a script.
• Fixed a syntax error that occurred when accessing columns whose names match the names of the built-in functions.
• Fixed a bug that occurred when working with Query Builder.
• Fixed symbol duplication that occurred when placing separators (Insert Semicolon) in the script.
• Fixed an issue with fetching data in Data Editor.
• Fixed a bug that occurred when working with Static Data in Source Control.