Features

• Improved detection when Replace Select Into With Create Table autofix is available.
• Added the ability to open SQL Dependency Tracker from the object definition window when viewing an object's dependencies. (SQL Toolbelt Essentials subscription license required).
• Added suggestions for existing resource pools for ALTER and DROP statements.

Fixes

• Fixed an error with the autofix for Add Columns To Insert Statement where it would fail for certain syntax.
• Fixed an issue where BEGIN END blocks could be incorrectly indented within IF ELSE statements.

Features

• Bulk Formatter added support for multiple file encodings.

Fixes

• Fixed an error where tab history sometimes crashes after executing a query.
• Fixed an issue where non-ranked suggestions would not be shown in alphabetical order.
• Fixed a missing tab coloring menu in the registered servers view.
• Fixed an issue where tabs could appear multiple times in the tab history window.

Fixes

• Fixed an issue where partition schemes would not show in the script preview for Azure SQL Database.
• Fixed a crash that could occur in the tab history window.
• Fixed an issue when auto-fixing ST008 on synonyms.

Fixes

• Fixed a crash when opening the formatting styles dialog without having an active query window open.
• Fixed an issue where database triggers were not being suggested when schema filtering is turned on.

Features

• Added the ability to share snippets with other users via the Redgate Platform. (SQL Toolbelt Essentials subscription license required).
• Added suggestions for existing functions when altering partition functions.
• Added suggestions for existing schemes when altering partition schemes.

Fixes

• Fixed an issue where including a column definition IDENTITY property could cause issues with suggestions for Azure SQL Database.
• Fixed an issue where Tab History entries sometimes couldn't be renamed.
• Fixed an issue where suggestions would not be given for column aliases in some UPDATE or DELETE queries.