You modify a table name or column name by executing ALTERTABLE with the RENAME operand specified.
Note
The table name or column name of a falsification prevented table cannot be changed.
Changing a table name or column name invalidates any stored routines that use that table. If this happens, use the ALTER PROCEDURE or ALTER ROUTINE statement to re-create each stored routine.
Changing a table name or column name of a table specified in a trigger SQL statement invalidates the trigger. If this happens, use the ALTER TRIGGER or ALTER ROUTINE statement to re-create the trigger.
The table name of a table that defines a trigger cannot be changed.
The column names of the following columns cannot be changed in a table that defines a trigger: Trigger event column Column that is referenced by a trigger action condition using an old and new values correlation name Column that is referenced by a trigger SQL statement using an old and new values correlation name