Freigeben über


Index.SecondaryXmlIndexType-Eigenschaft

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)

Eigenschaftswert

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

Hinweise

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

HinweisHinweis

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

Beispiele

Erstellen, Ändern und Löschen von Indizes

Siehe auch

Verweis

Index Klasse

Microsoft.SqlServer.Management.Smo-Namespace

Andere Ressourcen

Indizes

CREATE INDEX (Transact-SQL)