Dropping a Table With SQL

Previous

Next

To drop (remove completely) a table from the database, use the SQL DROP statement, as shown in Example: Dropping a Table Using SQL. Be careful when using the DROP statement to remove database objects.

If you want to delete the rows in the table and keep the table, use the DELETE statement. See "Deleting Data With the DELETE Statement".

-- drop tables from the database
-- use caution when use the DROP statement!
DROP TABLE birthdays;
DROP TABLE personal_info;