how to drop table in MySQL database

Remove table using SQL Query in MySQL

Remove table in my sql database using SQL Query in MySQL

Steps:

Open phpMyAdmin in your system.
Click on the SQL tab.
Paste the query

DROP TABLE Students;

Click the "Go" button.
You should see a success message.
Refresh the page to check if the Table is Remove successfully.

Syntax

DROP TABLE Table_name;

Note : In table name not allow " " space in beetween name use "_" for space.
column1 to column4 is coloum name you can modify and name give you according requirement.
datatype data type basically define a type of column . Example column1 is int show store integer value.

Example of remove a tabLe in MySQL:

You Can follow statement and remove table in Mysql

DROP TABLE Students;

when run this statement in sql remove a table in your database.

after delete table refresh database and see table is deleted :
how to create table in mysql database

Summery:

In this blog we are focus on how to remove a table in MySQL database using query. every one follow this blog and remove a table in mySQL easy way. I think this blog helping in remove a table in MySQL...