SqlPrimaryXmlIndexUsage Enumeration

Represents the types of secondary XML index.

Namespace:  Microsoft.Data.Schema.Sql.SchemaModel
Assembly:  Microsoft.Data.Schema.Sql (in Microsoft.Data.Schema.Sql.dll)

Syntax

'Declaration
Public Enumeration SqlPrimaryXmlIndexUsage
public enum SqlPrimaryXmlIndexUsage
public enum class SqlPrimaryXmlIndexUsage
type SqlPrimaryXmlIndexUsage
public enum SqlPrimaryXmlIndexUsage

Members

Member name Description
Unknown Indicates that the secondary XML index is unknown.
Path Creates a secondary XML index on columns that are built on path values and node values in the primary XML index.
Property Creates a secondary XML index on columns (PK, path, and node value) of the primary XML index where PK is the primary key of the base table.
Value Creates a secondary XML index on columns where key columns (node value and path) are of the primary XML index.

See Also

Reference

Microsoft.Data.Schema.Sql.SchemaModel Namespace