Designing constraints

When designing and creating constraints, it is a good idea to use a naming convention that properly identifies the different types constraints. This is particularly important for diagnosing errors that might occur.

About this task

You can design the following types of constraints:
  • NOT NULL constraints
  • Unique constraints
  • Primary key constraints
  • (Table) Check constraints
  • Foreign key (referential) constraints
  • Information constraints