Class SqlIndex

Namespace

LfrlAnvil.Sql.Objects

Assembly

LfrlAnvil.Sql.Core.dll

Represents an SQL index constraint.

public abstract class SqlIndex : SqlConstraint, ISqlIndex, ISqlConstraint, ISqlObject

Inheritance

object

SqlObject

SqlConstraint

SqlIndex

Implements

ISqlIndex

ISqlConstraint

ISqlObject

Derived

MySqlIndex

PostgreSqlIndex

Inherited Members

SqlConstraint.Table

SqlConstraint.ToString()

SqlObject.Database

SqlObject.Type

SqlObject.Name

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

Constructors

SqlIndex(SqlTable, SqlIndexBuilder)

Creates a new SqlIndex instance.

protected SqlIndex(SqlTable table, SqlIndexBuilder builder)

Parameters

table SqlTable

Table that this index belongs to.

builder SqlIndexBuilder

Source builder.

Properties

Columns

Collection of columns that define this index.

public SqlIndexedArray<SqlColumn> Columns { get; }

Property Value

SqlIndexedArray<SqlColumn>

IsPartial

Specifies whether or not this index is partial.

public bool IsPartial { get; }

Property Value

bool

IsUnique

Specifies whether or not this index is unique.

public bool IsUnique { get; }

Property Value

bool

IsVirtual

Specifies whether or not this index is virtual.

public bool IsVirtual { get; }

Property Value

bool

Remarks

Virtual indexes aren't actually created in the database.