Sdílet prostřednictvím

Index.SecondaryXmlIndexType Property

  • Článek

Gets or sets the secondary XML index type.

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

Syntax

'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.ReadOnlyAfterCreation Or SfcPropertyFlags.Standalone)> _
Public Property SecondaryXmlIndexType As SecondaryXmlIndexType 
    Get 
    Set
'Usage
Dim instance As Index 
Dim value As SecondaryXmlIndexType 

value = instance.SecondaryXmlIndexType

instance.SecondaryXmlIndexType = value

[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.ReadOnlyAfterCreation|SfcPropertyFlags.Standalone)]
public SecondaryXmlIndexType SecondaryXmlIndexType { get; set; }

[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::ReadOnlyAfterCreation|SfcPropertyFlags::Standalone)]
public:
property SecondaryXmlIndexType SecondaryXmlIndexType {
    SecondaryXmlIndexType get ();
    void set (SecondaryXmlIndexType value);
}

[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.ReadOnlyAfterCreation|SfcPropertyFlags.Standalone)>]
member SecondaryXmlIndexType : SecondaryXmlIndexType with get, set

function get SecondaryXmlIndexType () : SecondaryXmlIndexType 
function set SecondaryXmlIndexType (value : SecondaryXmlIndexType)

Property Value

Type: Microsoft.SqlServer.Management.Smo.SecondaryXmlIndexType
A SecondaryXmlIndexType object value that specifies the secondary XML index type.

Remarks

This property cannot be modified by using the Alter method. To change the property, the index must be rebuilt or re-created.

Note

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

Examples

Creating, Altering, and Removing Indexes

See Also

Reference

Index Class

Microsoft.SqlServer.Management.Smo Namespace

Other Resources

Indexes

CREATE INDEX (Transact-SQL)