DELETE Statements

DELETE statements are used to remove existing data from a table.

A DELETE statement will have 2 parts

  1. Specify the table that the record is to be deleted from

  2. The criteria to specify which record(s) will be deleted.

DELETE Statements - Single Record

The BMX Advanced course on the 4th May is now cancelled so should be deleted.

DELETE Query Design

SQL Statement Example

DELETE Statements - Multiple Records

An Instructor’s qualifications have changed so there will be no more Abseiling Courses

DELETE Query Design

SQL Tutorial 4 DELETE Statements

6 SQL DELETE.mp4

This video will demonstrate how to use a DELETE query to remove rows from a table.