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.
.webp)
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 :
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...