Updating a Table › Removing Data from a Table › Exercise 8-8

Exercise 8-8

Now You Try It

Department 5050 also should not be in the database. Delete it from the DEPARTMENT table.

Enter a SELECT statement to confirm the deletion. To check your answers, see Review Answers for Chapter 8.

Omitting the WHERE Clause

If you do not use the WHERE clause in the DELETE statement, all rows of data are deleted from the table. The empty table remains in the database.