Deleting Records

Records are removed from the database when they are no longer relevant to the application. For example, if an employee leaves the company, data concerning that person can be removed. Or if we wish to remove the data from certain departments which are not of interest to the pay raise analysis, we can delete those records from the temporary analysis table.

Deleting a record removes all data values in a row from a table. One or more rows from a table can be deleted with the use of the DELETE command. This command has the following form:

DELETE FROM  table-name
     [WHERE  search-condition] ;