Index.SecondaryXmlIndexType Property

 

Gets or sets the secondary XML index type.

Namespace:   Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.ReadOnlyAfterCreation Or SfcPropertyFlags.Standalone Or SfcPropertyFlags.SqlAzureDatabase)>
Public Property SecondaryXmlIndexType As SecondaryXmlIndexType

Property Value

Type: Microsoft.SqlServer.Management.Smo.SecondaryXmlIndexType

A SecondaryXmlIndexType object value that specifies the secondary XML index type.

This property cannot be modified by using the M:Microsoft.SqlServer.Managemetn.Smo.Index.Alter method. To change the property, the index must be rebuilt or re-created.

System_CAPS_noteNote

For indexes based on the UserDefinedTableType object the value of SecondaryXmlIndexType property is F;Microsoft.SqlServer.Management.Smo.SecondaryXmlIndexType.None.

Return to top
Show: