Why do constraints? What harmful actions does a referential integrity constraint prevent?
The benefits of the CONSTRAINT constraintname CHECK are usually obvious; why is the CHECK constraint no longer enforced in the CREATE TABLE? Where are the CHECK constraints that used to be in the CREATE TABLE placed in the current versions of the major DBMSs?