Removing Data

You 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, you must ensure that dependent data is also updated as needed.

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

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

DELETE Statement

Syntax

DELETE FROM [table] 

      	WHERE colunm1 = value1 AND column2 = value2

Example

DELETE FROM DEPARTMENTS WHERE DEPARTEMENT_ID = 50