Refactoring Overview

Refactoring is used to improve design of your database schemas. You can perform refactoring of database objects and in SQL scripts. Refactoring can be applied in online and offline (database projects) database development.

Renaming objects from the Database Explorer tree, object editors and scripts generated from the Database Explorer is considered a part of online database development.

Renaming objects from the project is considered a part offline database development.

Database objects that can be renamed during online database development

  • Tables
  • Columns

    Note

    If you rename a column with a trigger on it, the trigger will be recreated.

  • Views
  • Functions
  • Procedures

Database objects that can be renamed during offline database development

  • Tables
  • Views
  • Stored routines
  • Triggers
  • Events
  • Table and view columns
  • Stored routine parameters
  • Stored code variables
  • Users
  • Aliases

Note

Changes made by refactoring may be rolled back only if the changed files were opened before refactoring. In that case you may activate the corresponding document and press CTRL+Z to undo refactoring changes.