ImplementationDELETE

To delete the record for Tom Glacney, the following SQL would be used:

DELETE FROM Pupil

WHERE First Name = ‘Tom’ AND Surname = ‘Glacney’;

This would return:

Using the DELETE statement without a WHERE clause will delete all records held in the table. Both examples shown below would delete all records held in the pupil table.

DELETE FROM Pupil;

Or

DELETE * FROM Pupil;

It is unlikely that a developer would have need to delete all records from a table but it is important to understand that without a WHERE clause the records will all be removed.