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.
Columns
Note
If you rename a column with a trigger on it, the trigger will be recreated.
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.