Feature overview

dbForge Studio for SQL Server includes a refactoring feature that helps maintain code consistency and reduces the need for manual changes by automatically updating references when code elements are modified.

Renaming

You can modify identifiers throughout your code while maintaining all references and dependencies.

• Alias renaming: Changes alias names and updates all references automatically.
• Variable renaming: Replaces all occurrences of local and SQLCMD variables.
• Object renaming: Updates the database object names in scripts with reference tracking.

Code modification

You can transform and standardize SQL code structure for better readability and debugging.

• Insert Semicolons: Adds missing semicolons after statements throughout the document.
• Convert EXEC to Script: Converts stored procedure calls to their actual SQL code and transforms sp_executesql statements into standard SQL.

Common shortcuts

Shortcut	Action
F2	Rename the selected alias, variable, or object.
Ctrl+K, ;	Insert semicolons throughout the document.
Ctrl+Z	Undo the refactoring operation.