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 | SfcPropertyFlags.ReadOnlyAfterCreation | SfcPropertyFlags.Standalone | SfcPropertyFlags.SqlAzureDatabase)>]
member SecondaryXmlIndexType : SecondaryXmlIndexType with get, set

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: