Null Values



next up previous
Next: Referential Integrity Up: Domain Constraints Previous: Domain Types in

Null Values

  1. Null values occur when incomplete tuples are inserted into the database.
  2. Some null values are obviously inappropriate, e.g. a null customer name.
  3. We may wish to forbid null values on some attributes.
  4. SQL standard allows specification not null.
  5. We will want to do this especially in the primary key of a relation.



Page created and maintained by Osmar R. Zaï ane
Last Update: Mon Oct 16 17:01:17 PDT 1995