optimize performance when the NOT NULL constraint syntax is used as opposed to the CHECK constraint syntax given above.

Common restrictions

Most database management systems restrict check constraints to a single row, with access to constants and deterministic functions, but not to data in other tables, or to data invisible to the current transaction because of transaction isolation.

Such constraints are not truly table check constraints but rather

1.Previous
3.Next