Interface ISqlIndex

Namespace

LfrlAnvil.Sql.Objects

Assembly

LfrlAnvil.Sql.Core.dll

Represents an SQL index constraint.

public interface ISqlIndex : ISqlConstraint, ISqlObject

Inherited Members

ISqlConstraint.Table

ISqlObject.Name

ISqlObject.Type

ISqlObject.Database

Properties

Columns

Collection of columns that define this index.

IReadOnlyList<SqlIndexed<ISqlColumn>> Columns { get; }

Property Value

IReadOnlyList<SqlIndexed<ISqlColumn>>

IsPartial

Specifies whether or not this index is partial.

bool IsPartial { get; }

Property Value

bool

IsUnique

Specifies whether or not this index is unique.

bool IsUnique { get; }

Property Value

bool

IsVirtual

Specifies whether or not this index is virtual.

bool IsVirtual { get; }

Property Value

bool

Remarks

Virtual indexes aren't actually created in the database.