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?
- ALTER TABLE table_name RENAME TO new_table_name;
- RENAME new_table_name;
- 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;