DELETE

The DELETE command is employed to remove existing records from a table.

The provided SQL statement deletes the customer “Alfreds Futterkiste” from the “Customers” table.

Example

DELETE FROM Customers WHERE CustomerName=‘Alfreds Futterkiste’;

Caution: Exercise care when deleting records from a table! Observe the WHERE clause in the DELETE statement, as it determines which

record(s) should be deleted. Omitting the WHERE clause will result in the deletion of all records in the table!

You can delete all rows in a table without removing the table itself. This preserves the table structure, attributes, and indexes.

The following SQL statement accomplishes this by deleting all rows in the “Customers” table while leaving the table structure, attributes, and indexes intact:

Example

DELETE FROM Customers;