Partager via


Propriété Index.SecondaryXmlIndexType

Gets or sets the secondary XML index type.

Espace de noms :  Microsoft.SqlServer.Management.Smo
Assembly :  Microsoft.SqlServer.Smo (en Microsoft.SqlServer.Smo.dll)

Syntaxe

'Déclaration
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.ReadOnlyAfterCreation Or SfcPropertyFlags.Standalone)> _
Public Property SecondaryXmlIndexType As SecondaryXmlIndexType 
    Get 
    Set
'Utilisation
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)

Valeur de propriété

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

Notes

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

[!REMARQUE]

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

Exemples

Création, modification et suppression d'index

Voir aussi

Référence

Index Classe

Espace de noms Microsoft.SqlServer.Management.Smo

Autres ressources

Index

CREATE INDEX (Transact-SQL)