Deleting a table v16
You can remove rows 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 careful when giving a
DELETE command without a
WHERE clause such as the following:
This statement removes all rows from the given table, leaving it completely empty. The system doesn't request confirmation before doing this.