Class SqlCreateIndexNode

Represents an SQL syntax tree statement node that defines creation of a single index.

public sealed class SqlCreateIndexNode : SqlNodeBase, ISqlStatementNode

Inherited Members: SqlNodeBase.NodeType

SqlNodeBase.ToString()

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.ReferenceEquals(object, object)

Properties

Collection of expressions that define this index.

public ReadOnlyArray<SqlOrderByNode> Columns { get; }

Optional filter condition.

public SqlConditionNode? Filter { get; }

Specifies whether or not this index is unique.

public bool IsUnique { get; }

Index's name.

public SqlSchemaObjectName Name { get; }

Specifies whether or not the index should be replaced if it already exists in DB.

public bool ReplaceIfExists { get; }

Table on which this index is created.

public SqlRecordSetNode Table { get; }