DB2 DELETE Statement

Code Example

## DB2 DELETE Statement

DELETE removes rows from a table.

### Basic Syntax
\`\`\`sql
DELETE FROM table-name
WHERE condition
\`\`\`

### Delete Specific Rows
\`\`\`sql
DELETE FROM EMP
WHERE EMP_ID = 'E001'
\`\`\`

### Delete with Subquery
\`\`\`sql
DELETE FROM EMP
WHERE DEPT IN (SELECT DEPT FROM INACTIVE_DEPTS)
\`\`\`

### Delete All Rows
\`\`\`sql
DELETE FROM EMP
\`\`\`
Note: Use TRUNCATE for faster bulk delete.

### WARNING
Without WHERE, deletes ALL rows!

### Referential Integrity
May fail if rows referenced by foreign key.