SQL DROP TABLE

 SQL DROP TABLE

Use the DROP TABLE statement to delete any existing table in the MySQL database. This deletes all table data and structures.

Syntax:

DROP TABLEtable_name;

Example – MySQL Drop Table

For example, I have table users in the database. I need to remove its data completely with structure. Login to your MySQL server and select database. Now execute the below query to remove the database.

DROP TABLE users;