Managing Constraints

What Are Constraints?

Data integrity ensures the consistency and correctness of data stored in a database. Such integrity can be enforced by incorporating business rules. Constraints are the rules that are enforced on data stored in a table.

Why Should I Use Constraints?

You can use constraints to do the following:

• Enforce rules on the data in a table whenever a row is updated, inserted, or deleted from that table
• Prevent the deletion of a table if there are dependencies from other tables