Delete an entire row type
To delete all fields in a row-type column, specify the table, view, or synonym name after the FROM keyword of the DELETE statement and use the WHERE clause to identify the table row or rows that you want to delete.
The following DELETE statement deletes the row in the tab_unmrow table
that contains the row type that the UPDATE statement in Updating a row-type
column saves:
EXEC SQL delete from tab_unmrow
where area = 20;