| DELETE FROM | Table Name |
| WHERE | conditions |
When using the DELETE statement, DELETE FROM is followed by the Table Name that contains the record to be deleted. The condition of the record to be deleted is specified in the WHERE field, and the DELETE statement deletes all records matching the WHERE condition; if no WHERE condition is specified, all records are deleted.
If you want to delete all employee records, do the following
| DELETE FROM | EMP |
To delete the record of Mr. SMITH (Employee Number:7369) in the EMP Table, the following will be used.
| DELETE FROM | EMP |
| WHERE | EMPNO = 7369 |
This completes the DELETE statement.