Share via

2.2.3.70 CT_DefaultConstraint

  • Article

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

Referenced by: DefaultConstraint

Specifies a default constraint (section 2.1.1.2) on a column in a table.

Child Elements:

Expression: A CT_ExpressionContents (section 2.2.3.45) element that specifies the default value.

PropertyRef: A CT_PropertyRef element (section 2.2.3.87) that specifies the name of the column.

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_DefaultConstraint">
   <xsd:complexContent>
     <xsd:restriction base="CT_ConstraintWithExpression">
       <xsd:sequence>
         <xsd:element name="PropertyRef" wbld:cname="PropertyRef" type="CT_PropertyRef"/>
         <xsd:element name="Expression" wbld:cname="Expression" type="CT_ExpressionContents"/>
       </xsd:sequence>
     </xsd:restriction>
   </xsd:complexContent>
 </xsd:complexType>

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