Share via

2.2.3.69 CT_CheckConstraint

  • Article

Target namespace: http://schemas.microsoft.com/office/accessservices/2010/12/application

Referenced by: CheckConstraint

Specifies a check constraint (section 2.1.1.1) on a table or on a single column.

Child Elements:

Expression: A CT_ExpressionContents (section 2.2.3.45) element that specifies an expression.

PropertyRef: A CT_PropertyRef element (section 2.2.3.87) that specifies the name of the column with which this constraint is associated.

Attributes:

CheckData: A boolean ([XMLSCHEMA2] section 3.2.2) attribute that specifies whether to check existing data in the column or table for constraint violations.

Message: An ST_ShortString (section 2.2.4.3) attribute that specifies the message associated with a constraint violation.

Name: An ST_ObjectName attribute (section 2.2.4.1) that specifies the name of the constraint.

ObjectId: An ST_ObjectName attribute (section 2.2.4.1) that specifies an identifier for the constraint.

The following W3C XML Schema ([XMLSCHEMA1/2] section 2.1) fragment specifies the contents of this complex type.

 <xsd:complexType name="CT_CheckConstraint">
   <xsd:complexContent>
     <xsd:extension base="CT_ConstraintWithExpression">
       <xsd:attribute name="CheckData" wbld:cname="CheckData" type="xsd:boolean" use="optional" form="qualified"/>
       <xsd:attribute name="Message" wbld:cname="Message" type="ST_ShortString" use="optional" form="qualified"/>
     </xsd:extension>
   </xsd:complexContent>
 </xsd:complexType>

See section 5.1 for the full W3C XML Schema ([XMLSCHEMA1/2] section 2.1).