The statement to change the table name is . . . . . . . .
A. CHANGE
B. CHANGENAME
C. CHANGENM
D. RENAME
Answer: Option D
Solution(By Examveda Team)
In MySQL, the statement used to change the table name is RENAME.This statement is followed by the current table name and the new desired table name.
It allows you to rename an existing table in the database.
Option A, CHANGE, is incorrect because it is used in ALTER TABLE statements to change the name or datatype of a column, not to rename the entire table.
Option B, CHANGENAME, and Option C, CHANGENM, are incorrect because there is no such statement as CHANGENAME or CHANGENM in MySQL for changing the table name.
Join The Discussion