Is it possible to automatically rename fields, tables in the database?

Question

MySQL

Good afternoon, there is some table cf_2233, I need to rename it to currencies, but the problem is that in the database this table is mentioned in other tables as a field name, i.e. left_table.cf_2233 and as the cell value itself in the table.
tell me how to make a mass replacement of cf_2233 with currencies.

Answer 1

No way. You will have to write a transaction with the removal of Foreign Keys and indexes, if any, and then create it all again after renaming the field