The DELETE statement deletes rows from a table or view. Deleting a row from a view also deletes the row from the table on which the view is based.
You can use SQL Assist to build your DELETE statement. See SQL Assist for more information.
Delete department (DEPTNO) 'D11' from the DEPARTMENT table. After executing the statement in SQL scripts, the message tab displays a message: n rows were affected by the statement, where n is the number of rows deleted.
DELETE FROM CORPDATA.DEPARTMENT WHERE DEPTNO = 'D11'
Delete all the departments from the DEPARTMENT table (that is, empty the table).
DELETE FROM DEPARTMENT
For expressions and clauses to use with DELETE, see Expressions.
For more information, see DELETE in the SQL Reference topic in the
Information Center.