Previous Next

What's New in dbForge SQL Complete v5.7

SQL Server Support

  • SQL Server 2016 Service Pack 1 (SP1) new syntax support
  • SQL Server 2017 CTP2 new syntax support
  • Azure SQL Data Warehouse connectivity support
dbForge Schema Compare - SQL Server Support

Integration

SQL Complete can be integrated into the latest SQL Server Management Studio v17.2.

Code Completion

  • Highlight of matching columns in the INSERT statement
  • Exclusion of database elements from the Completion List prompt
  • Option to exclude schema in the ON condition of the JOIN statement
  • Option to connect/disconnect when describing/pre-describing objects of the same database
  • Query navigation
  • CASE END pair highlighting
  • Generation of the CREATE/ALTER script for server objects with the object decryption option
  • Extended suggestion in the PIVOT/UNPIVOT queries
  • Extended support for CTE
  • Prompt and QI of variables in named transactions
  • CREATE OR ALTER statement support
  • Display of the estimated row count for tables
Extended Code Completion support for:
  • Object prompting in:
    • CREATE OR ALTER statements
    • DROP ROUTE
    • ALTER ROUTE
    • DROP SERVICE
    • ALTER SERVICE
    • DROP RULE
    • DROP CONTRACT
    • ALTER QUEUE
    • CREATE PARTITION FUNCTION
  • Syntax support for:
    • CREATE ( ALTER, DROP ) COLUMN ENCRYPTION KEY
    • ALTER EXTERNAL DATA SOURCE
    • ALTER EXTERNAL RESOURCE POOL
    • CREATE EXTERNAL TABLE AS SELECT
    • CREATE REMOTE TABLE AS SELECT
    • STRING_AGG
    • CONCAT_WS
    • TRANSLATE
    • TRIM
    • BULK INSERT and OPENROWSET ( BULK... )
    • BLOB_STORAGE option of EXTERNAL DATA SOURCE
    • DBCC CLONEDATABASE
    • ALTER ANY MASK
    • BACKUP (RESTORE) DATABASE TO URL
    • ALLOW_ENCRYPTED_VALUE_MODIFICATIONS

Execution History

The query execution history feature can store all the information about all SQL statements executed for the particular period of time. It allows users to track the duration of the executed statements, their status, as well as set filters by the execution date. In addition, you can check who ran the statement and when it was completed.

Other Improvements

  • Tab coloring
  • Enabling/disabling SQL Complete from the menu
  • Generate Script As from the SSMS shortcut menu

For a complete list of changes, see the revision history.