Class TableIndex

Represents a Microsoft SQL Server table index.

System.Object

TableIndex

Version: 14.26.0

public class TableIndex : Object

Initializes a new instance of the TableIndex class.

public TableIndex(string tableName, string indexName, string[] indexKeys)

Gets the index keys.

public Dictionary<string, bool> IndexKeys { get; }

Type	Description
System.Collections.Generic.Dictionary<System.String, System.Boolean>	The index keys.

Gets a value indicating whether this instance is clustered index.

public bool IsClusteredIndex { get; }

Type	Description
System.Boolean	`true` if this instance is clustered index; otherwise, `false`.

Gets a value indicating whether this instance is primary key index.

public bool IsPrimaryKeyIndex { get; }

Type	Description
System.Boolean	`true` if this instance is primary key index; otherwise, `false`.

Creates the index.

public void CreateIndex()

Drops the index.

public void DropIndex()

Gets the index of the table.

public static TableIndex[] GetTableIndex(string tableName)

Type	Name	Description
System.String	tableName	Name of the table.

Type	Description
TableIndex[]