DB2 - SQL Delete Statement

The DELETE statement delete rows from a table.

Syntax:

DELETE FROM table_name WHERE condition;

Note: If there is no “where” clause in the Delete statement, then SQL will delete all the data in the table. So you need to be very careful while executing the Delete statement and make sure that there is a Where clause.

DB2 Database:

Below is a selection from the "Product" table in the DB2 database:

Example 1: Delete One Record

Delete 'ProductID' 7003 from 'Product' table.

DELETE FROM Product WHERE ProductID = ‘7003’;

Result:

Example 2: Delete All Records

Delete all the departments from 'Product' table (that is, empty the table).

The following SQL statement deletes all rows in the "Product" table, without deleting the table.

DELETE FROM Product;

Result:

Empty table

If you have any doubts or queries related to this chapter, get them clarified from our Mainframe experts on ibmmainframer Community!