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 use the Application Express Object Browser interface to remove rows. She can also 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