How to Rename Table in MySQL
Notes:
How to rename a table in MySQL:
- To rename a table; we take help of alter table command
Basic Syntax:
alter table current_name_of_the_table rename new_name_for_the_table;
Ex:
alter table student_table rename tbl_student;
Interview Questions: