dbForge SQL Tools V5.8.29

dbForge SQL Complete

• Added full support for Microsoft SQL Server 2019.
• Added properties for built-in metadata functions (SERVERPROPERTY, FILEPROPERTY, DATABASEPROPERTYEX, etc.).
• Added temporary table suggestions.
• Added OPENJSON object suggestions.
• Added support for the following functions: NEWSEQUENTIALID, CERTPRIVATEKEY, CERTENCODED, PWDENCRYPT and PWDCOMPARE
• Added 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 SQL Server 2019 PREDICT function.
• Expanded support for the following statements:
  • Microsoft Azure SQL Database
    • CREATE USER
  • Microsoft SQL Server 2019
    • CREATE INDEXCREATE EXTERNAL LIBRARY
    • ALTER DATABASE
    • ALTER TABLE
    • ALTER EXTERNAL LIBRARY
    • ALTER AVAILABILITY GROUP
    • DROP EXTERNAL RESOURCE POOL
    • DROP EXTERNAL LIBRARY
    • ACCELERATED_DATABASE_RECOVERY in ALTER DATABASE
• Added SSMS v18.5 integration.