les13_管理约束.pptVIP

Maintaining Data Integrity Objectives After completing this lesson, you should be able to do the following: Implement data integrity constraints Maintain integrity constraints Obtain constraint information Data Integrity Types of Constraints Constraint States Constraint Checking Defining ConstraintsImmediate or Deferred Use the SET CONSTRAINTS statement to make constraints either DEFERRED or IMMEDIATE. The ALTER SESSION statement also has clauses to set constraints to DEFERRED or IMMEDIATE. Primary and Unique Key Enforcement Foreign Key Considerations Defining Constraints WhileCreating a Tab