LaunchIdea
MySQL

how to drop table in MySQL database

Nov 8, 2024, 5:15 PM
Blog Thumbnail

Remove table using SQL Query in MySQL

Remove table in my sql database using SQL Query in MySQL

Steps:

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

    DROP TABLE Students;

    4. how to create table in mysql database
  4. Click the "Go" button.
  5. You should see a success message.
  6. Refresh the page to check if the Table is Remove successfully.
    7. how to create table in mysql database

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