Check constraint: Difference between revisions

Content deleted Content added
Stolze (talk | contribs)
Added syntax information
Stolze (talk | contribs)
most DBMS only support "row check constraints"
Line 32:
)
 
== Common Restrictions ==
==External link ==
 
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]