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. |