Comments on: Table refactoring & application version upgrades, Part I https://shlomi-noach.github.io/blog/mysql/table-refactoring-application-version-upgrades-part-i Blog by Shlomi Noach Thu, 12 Aug 2010 10:45:03 +0000 hourly 1 https://wordpress.org/?v=5.3.3 By: Devart https://shlomi-noach.github.io/blog/mysql/table-refactoring-application-version-upgrades-part-i/comment-page-1#comment-16583 Thu, 12 Aug 2010 10:45:03 +0000 https://shlomi-noach.github.io/blog/?p=2775#comment-16583 Refactoring can be used for renaming database objects. To rename columns, that are referenced by foreign keys, we need to modify foreign keys too. dbForge Studio for MySQL automates this process.
To rename such column dbForge Studio performs the following steps:
Lock tables;
Delete foreign keys;
Rename the column;
Recreate the keys;
Unlock the tables.

dbForge Studio for MySQL Overview –
http://www.devart.com/dbforge/mysql/studio/

]]>