Share via

2.2.3.68 CT_ConstraintWithExpression

  • Article

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

Referenced by: CT_CheckConstraint, CT_DefaultConstraint

Specifies a constraint on a table or on a column. MUST NOT have a PropertyRef child element for a table-wide constraint. MUST have one PropertyRef child element if the constraint is associated with a 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:

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_ConstraintWithExpression">
   <xsd:sequence>
     <xsd:element name="PropertyRef" wbld:cname="PropertyRef" type="CT_PropertyRef" minOccurs="0"/>
     <xsd:element name="Expression" wbld:cname="Expression" type="CT_ExpressionContents"/>
   </xsd:sequence>
   <xsd:attribute name="Name" wbld:cname="Name" type="ST_ObjectName" use="required" form="qualified"/>
   <xsd:attribute name="ObjectId" wbld:cname="ObjectId" type="ST_ObjectName" form="qualified"/>
 </xsd:complexType>

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