Home » MCQs » MySQL MCQs

Which of the following syntax you will use to rename the table name?

42. Which of the following syntax you will use to rename the table name?

1. ALTER TABLE table_name RENAME TO new_table_name;
2. RENAME new_table_name;
3. ALTER table_name RENAME new_table_name;

Answer: A) ALTER TABLE table_name RENAME TO new_table_name;

Explanation:

To rename the table we will use:

ALTER TABLE table_name RENAME TO new_table_name;