Rename Command
This command helps us to change the name of an existing table.
Syntax:
Rename oldname to newname;
Example:
rename std to student;
rename prod to product;
Drop table command
This command helps us to permanently remove the table from the database . All the records and structure of the table also gets removed and cannot be rolled back.
Syntax:
Drop table tablename;
Example:
drop table std;
drop table product;
