WebDevelopersNotes logo

home-icon Home / MySQL / my sql tutorial – Dropping tables

my sql tutorial – Dropping tables

my sql tutorial - Dropping tables

To remove all entries from the table we can issue the DELETE statement without any conditions.

DELETE from employee_data;
Query OK, 0 rows affected (0.00 sec)

However, this does not delete the table. The table still remains, which you can check with SHOW TABLES;

mysql> SHOW TABLES;
+---------------------+
| Tables in employees |
+---------------------+
| employee_data       |
+---------------------+
1 rows in set (0.00 sec)

To delete the table, we issue a DROP table command.

DROP TABLE employee_data;
Query OK, 0 rows affected (0.01 sec)

Now, we won’t get this table in SHOW TABLES; listing

Sponsored Links

Your comments
Star icon IMPORTANT Have a question / problem? Click here to ask an expert.

Sponsored Links

Tips

How do I view a deleted web page?
Is there a way to view a deleted web page - one that is no longer available? Yes there is and the solution is quite simple. [more...]

Fact

In an attempt to tap the high-net-worth individuals, Nations Luxury Transportation, LLC, purchased PrivateJet.com domain name for $30.2 Million in February 2012. [more...]

We use cookies to give you the best possible website experience. By using WebDevelopersNotes.com, you agree to our Privacy Policy