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.

Why should you delete web browser history?

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

The WWW was invented by Sir Tim Berners-Lee on the NeXTSTEP operating system. The same OS forms the source of Apple's OS X, iOS, watchOS and tvOS. NeXTSTEP was originally written for the NeXT computer and is based on UNIX. [more...]

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