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.

Want to Find out More?

Overview

Overview

Take a quick tour to learn all about the key benefits delivered by dbForge Studio for MySQL.
All Features

All features

Get acquainted with the rich features and capabilities of the Studio in less than 5 minutes.
Request a demo

Request a demo

If you consider employing the Studio for your business, request a demo to see it in action.
Ready to start using dbForge Studio for MySQL?