Check constraint: Difference between revisions

Revision as of 13:43, 15 February 2007

Revision as of 03:35, 25 February 2007

Line 35:

Most database management systems restrict check constraints to a single row. References to data stored in other tables is not allowed. At most constants and deterministic functions (that do not refer to other tables) are supported. Such constraints are not truly ''table check constraints'' but rather ''row check constraints''. [[Database trigger|Triggers]] can be used to work around this restriction.

== External link ==

* [http://publib.boulder.ibm.com/infocenter/db2luw/v8/index.jsp?topic=/com.ibm.db2.udb.doc/admin/t0004984.htm Defining a table check constraint in DB2]

[[Category:Databases]]