(SQL) DELETE: Deleting a Row, Table, whole DataBase

(Substantially borrowed from W3Schools)

The DELETE statement is used to delete existing records in a table.

DELETE Syntax

DELETE FROM table_name WHERE condition;

Note: Be careful when deleting records in a table! Notice the WHERE clause in the DELETE statement. The WHERE clause specifies which record(s) should be deleted. If you omit the WHERE clause, all records in the table will be deleted!

Example

The following SQL statement deletes the customer Alfreds Futterkiste from the Customers table:

DELETE FROM Customers WHERE CustomerName='Alfreds Futterkiste';

Deleting a Table

If you DELETE FROM a table, then you will be deleting all rows in a table without deleting the table. This means that the table structure, attributes, and indexes will be intact.

The following SQL statement deletes all rows in the Customers table, without deleting the table:

DELETE FROM Customers;

To delete the table completely, use the DROP TABLE statement.

To remove the Customers table, execute:

DROP TABLE Customers;