2.2.3.66 CT_Index

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

Referenced by: CT_Unique, Index

Specifies an index (section 2.1.1.3) on a table.

Child Elements:

PropertyRef: A CT_PropertyRefIndex element (section 2.2.3.88) that specifies the name of a column that is part of the index.

Attributes:

Caption: An ST_LongString attribute (section 2.2.4.4) that specifies a caption for the index.

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

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

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

 <xsd:complexType name="CT_Index">
   <xsd:sequence>
     <xsd:element name="PropertyRef" type="CT_PropertyRefIndex" wbld:cname="PropertyRef" maxOccurs="unbounded"/>
   </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:attribute name="Caption" type="ST_LongString" wbld:cname="Caption" form="qualified"/>
 </xsd:complexType>

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