What’s New in dbForge SQL Complete v5.0

Statement Expansion

  • UPDATE statement support New Snippets
  • BEGIN TRANSACTION
  • ROLLBACK TRANSACTION

Custom Alias Mapping

This feature allows users to assign custom aliases to a table, view, table-valued function, or synonym referenced to in an SQL document.

Pair Highlighting

This feature highlights both the opening and closing code elements to visually define separate code blocks and determine mismatched or misspelled paired code elements.

Code Refactoring

The Rename functionality changes all occurrences of variable names and object names to new ones, automatically finds and corrects all references to them. The Rename refactoring is available for tables, temporary tables and columns, views, stored procedures, functions, local variables, and SQLCMD variables. emicolon Insertion This feature allows to insert missing semicolons after each statement in a query.

SSDT Project Support

SQL Complete is now available in SSDT SQL Server projects.