Detailed explanation and options for the selected question.
RENAME TABLE is used to change the name of a table. ALTER TABLE modifies structure, and MODIFY TABLE and UPDATE TABLE are invalid for renaming.