Class CreateIndexTask

Creates an index if the index doesn't exists, otherwise the index is dropped and recreated.

Inheritance

System.Object

GenericTask

CreateIndexTask

Implements

ITask

Inherited Members

GenericTask.TaskType

GenericTask.NLogger

GenericTask.ConnectionManager

GenericTask.ConnectionType

GenericTask.QB

GenericTask.QE

GenericTask._disableLogging

GenericTask.DisableLogging

GenericTask.TaskHash

GenericTask.CopyTaskProperties(ITask)

System.Object.Equals(System.Object)

System.Object.Equals(System.Object, System.Object)

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

System.Object.ReferenceEquals(System.Object, System.Object)

System.Object.ToString()

Namespace: ETLBox.ControlFlow.Tasks

Assembly: ETLBox.dll

Syntax

public class CreateIndexTask : GenericTask, ITask

Examples

CreateIndexTask.Create("indexname","tablename", indexColumns)

Constructors

CreateIndexTask()

Declaration

public CreateIndexTask()

CreateIndexTask(String, String, IList<String>)

Declaration

public CreateIndexTask(string indexName, string tableName, IList<string> indexColumns)

Parameters

Type	Name	Description
System.String	indexName
System.String	tableName
System.Collections.Generic.IList<System.String>	indexColumns

CreateIndexTask(String, String, IList<String>, IList<String>)

Declaration

public CreateIndexTask(string indexName, string tableName, IList<string> indexColumns, IList<string> includeColumns)

Parameters

Type	Name	Description
System.String	indexName
System.String	tableName
System.Collections.Generic.IList<System.String>	indexColumns
System.Collections.Generic.IList<System.String>	includeColumns

Properties

IN

Declaration

public ObjectNameDescriptor IN { get; }

Property Value

Type	Description
ObjectNameDescriptor

IncludeColumns

Declaration

public IList<string> IncludeColumns { get; set; }

Property Value

Type	Description
System.Collections.Generic.IList<System.String>

IndexColumns

Declaration

public IList<string> IndexColumns { get; set; }

Property Value

Type	Description
System.Collections.Generic.IList<System.String>

IndexName

Declaration

public string IndexName { get; set; }

Property Value

Type	Description
System.String

IsClustered

Declaration

public bool IsClustered { get; set; }

Property Value

Type	Description
System.Boolean

IsUnique

Declaration

public bool IsUnique { get; set; }

Property Value

Type	Description
System.Boolean

Sql

Declaration

public string Sql { get; }

Property Value

Type	Description
System.String

TableName

Declaration

public string TableName { get; set; }

Property Value

Type	Description
System.String

TaskName

Declaration

public override string TaskName { get; }

Property Value

Type	Description
System.String

Overrides

GenericTask.TaskName

TN

Declaration

public ObjectNameDescriptor TN { get; }

Property Value

Type	Description
ObjectNameDescriptor

Methods

CreateOrRecrate()

Declaration

public void CreateOrRecrate()

CreateOrRecreate(IConnectionManager, String, String, IList<String>)

Declaration

public static void CreateOrRecreate(IConnectionManager connectionManager, string indexName, string tableName, IList<string> indexColumns)

Parameters

Type	Name	Description
IConnectionManager	connectionManager
System.String	indexName
System.String	tableName
System.Collections.Generic.IList<System.String>	indexColumns

CreateOrRecreate(IConnectionManager, String, String, IList<String>, IList<String>)

Declaration

public static void CreateOrRecreate(IConnectionManager connectionManager, string indexName, string tableName, IList<string> indexColumns, IList<string> includeColumns)

Parameters

Type	Name	Description
IConnectionManager	connectionManager
System.String	indexName
System.String	tableName
System.Collections.Generic.IList<System.String>	indexColumns
System.Collections.Generic.IList<System.String>	includeColumns

CreateOrRecreate(String, String, IList<String>)

Declaration

public static void CreateOrRecreate(string indexName, string tableName, IList<string> indexColumns)

Parameters

Type	Name	Description
System.String	indexName
System.String	tableName
System.Collections.Generic.IList<System.String>	indexColumns

CreateOrRecreate(String, String, IList<String>, IList<String>)

Declaration

public static void CreateOrRecreate(string indexName, string tableName, IList<string> indexColumns, IList<string> includeColumns)

Parameters

Type	Name	Description
System.String	indexName
System.String	tableName
System.Collections.Generic.IList<System.String>	indexColumns
System.Collections.Generic.IList<System.String>	includeColumns

Execute()

Declaration

public void Execute()

Implements

ITask