Data Manipulation

Delete a Table or Database

To delete a table (the table structure, attributes, and indexes will also be deleted):

To delete a database:

Truncate a Table

What if we only want to get rid of the data inside a table, and not the table itself? Use the TRUNCATE TABLE command (deletes only the data inside the table):