通过

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)