共用方式為


Index.SecondaryXmlIndexType 屬性

Gets or sets the secondary XML index type.

命名空間:  Microsoft.SqlServer.Management.Smo
組件:  Microsoft.SqlServer.Smo (在 Microsoft.SqlServer.Smo.dll 中)

語法

'宣告
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.ReadOnlyAfterCreation Or SfcPropertyFlags.Standalone)> _
Public Property SecondaryXmlIndexType As SecondaryXmlIndexType 
    Get 
    Set
'用途
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)

屬性值

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

備註

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

[!附註]

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

範例

建立、改變和移除索引

請參閱

參考

Index 類別

Microsoft.SqlServer.Management.Smo 命名空間

其他資源

索引

CREATE INDEX (Transact-SQL)