Examveda
Examveda

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.

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous