DROP statement

​

Overview

In this section, we will learn how to delete the data from a table using the DROP statement.

​

Syntax

The basic syntax for the DROP statement is as follows:

DROP TABLE table_name;

In this syntax, we have several elements that are elaborated on below.

1. DROP represents the statement name.

2. TABLE entity type you want to drop.

3. table_name defines which table you want to remove.

​

Example

We have a table named warehouse that stores the product’s id, name, and quantity:

CREATE TABLE warehouse (
  id int,
  product string,
  qty int
);
INSERT INTO warehouse 
    (id, product, qty) 
VALUES 
    (889771,'Shirt',22),
    (777821,'Hat',99),
    (103829,'Bed Cover',12);

 SELECT * FROM warehouse;

It will create a table as shown below:

+---------+------------+---------+
| id      | product    | qty     | 
+---------+------------+---------+
| 889771  | Shirt      | 22      |
| 777821  | Hat        | 99      |
| 103829  | Bed Cover  | 12      |
+---------+------------+---------+

1. Use the following query to delete the warehouse’s table:

DROP TABLE warehouse;

2. If you have successfully run the query, you will get the following output: the table and the values within it are deleted.

DROP TABLE

Query returned successfully in 284 msec.