Rows can be removed from a table using the
DELETE command. For example, the following sequence of commands shows the before and after results of deleting all employees in department
Be extremely careful of giving a
DELETE command without a
WHERE clause such as the following:
This statement will remove all rows from the given table, leaving it completely empty. The system will not request confirmation before doing this.