Drop
Drop Table
# Drop Single Table
DROP TABLE `teacher`;
DROP TABLE IF EXISTS `teacher`;
# Drop Single Table from a Database
DROP TABLE `database_name`.`teacher`;
DROP TABLE IF EXISTS `database_name`.`teacher`;
# Drop Multiple Tables
DROP TABLE `teacher`, `student`;
DROP TABLE IF EXISTS `teacher`, `student`;
# Drop Multiple Tables from a Database
DROP TABLE `database_name`.`teacher`, `database_name`.`student`;
DROP TABLE IF EXISTS `database_name`.`teacher`, `database_name`.`student`;
Last updated
Was this helpful?