Removing Data

Sheila can remove data from the database at any time by deleting the data from a table. This may be required to remove redundant or duplicate information. When removing data, Sheila must ensure that dependent data is also updated as needed.

Sheila can remove rows from a table by using the DELETE statement, which does the following:

• Allows her to remove all rows from a table
• Enables her to delete rows conditionally
• Prevents her from deleting rows that are protected by referential integrity constraints