Check constraint: Difference between revisions

Content deleted Content added
NOT NULL Constraint: // clean up using AWB
Line 37:
CHECK (''column'' IS NOT NULL)
 
Some [[Relationalrelational database management system|relational database management systems]]s are able to optimize performance when the <code>NOT NULL</code> constraint syntax is used as opposed to the CHECK constraint syntax given above.<ref>PostgreSQL 8.3devel Documentation, Chapter 5. ''Data Definition'', Section 5.3.2. ''Not-Null Constraints'', Website: http://developer.postgresql.org/pgdocs/postgres/ddl-constraints.html, Accessed on May 5, 2007</ref>
 
== Common Restrictions ==