# DropIndexTask {{< rawhtml >}}

Class DropIndexTask

Drops an index. Use DropIfExists to drop an index only if it exists.

Inheritance

ControlFlowTask

DropTask<IfIndexExistsTask>

DropIndexTask

Implements

Inherited Members

DropTask<IfIndexExistsTask>.ObjectName

DropTask<IfIndexExistsTask>.ON

DropTask<IfIndexExistsTask>.Sql

DropTask<IfIndexExistsTask>.Drop()

DropTask<IfIndexExistsTask>.DropIfExists()

ControlFlowTask.ConnectionManager

ControlFlowTask.ConnectionType

ControlFlowTask.QB

ControlFlowTask.QE

LoggableTask.TaskType

LoggableTask.TaskName

LoggableTask.DisableLogging

LoggableTask.LogThreshold

LoggableTask.TaskHash

LoggableTask.LogInstance

LoggableTask.ParentTask

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.ReferenceEquals(object, object)

object.ToString()

Namespace: ETLBox.ControlFlow

Assembly: ETLBox.dll

Syntax

{{< /rawhtml >}} ```C# public sealed class DropIndexTask : DropTask, ILoggableTask ``` {{< rawhtml >}}

Constructors

DropIndexTask()

Declaration

{{< /rawhtml >}} ```C# public DropIndexTask() ``` {{< rawhtml >}}

DropIndexTask(string, string)

Declaration

{{< /rawhtml >}} ```C# public DropIndexTask(string indexName, string tableName) ``` {{< rawhtml >}}

Parameters

Type	Name	Description
string	indexName
string	tableName

Properties

TN

The formatted table name on which the index is based on.

Declaration

{{< /rawhtml >}} ```C# public ObjectNameDescriptor TN { get; } ``` {{< rawhtml >}}

Property Value

Type	Description
ObjectNameDescriptor

TableName

The table name on which the index is based on.

Declaration

{{< /rawhtml >}} ```C# public string TableName { get; } ``` {{< rawhtml >}}

Property Value

Type	Description
string

Methods

Drop(IConnectionManager, string, string)

Drops an index.

Declaration

{{< /rawhtml >}} ```C# public static void Drop(IConnectionManager connectionManager, string indexName, string tableName) ``` {{< rawhtml >}}

Parameters

Type	Name	Description
IConnectionManager	connectionManager	The connection manager of the database you want to connect
string	indexName	The index name to drop.
string	tableName	The table name the index is based on.

Drop(string, string)

Drops an index.

Declaration

{{< /rawhtml >}} ```C# public static void Drop(string indexName, string tableName) ``` {{< rawhtml >}}

Parameters

Type	Name	Description
string	indexName	The index name to drop.
string	tableName	The table name the index is based on.

DropIfExists(IConnectionManager, string, string)

Drops an index if the index exists.

Declaration

{{< /rawhtml >}} ```C# public static void DropIfExists(IConnectionManager connectionManager, string indexName, string tableName) ``` {{< rawhtml >}}

Parameters

Type	Name	Description
IConnectionManager	connectionManager	The connection manager of the database you want to connect
string	indexName	The index name to drop.
string	tableName	The table name the index is based on.

DropIfExists(string, string)

Drops an index if the index exists.

Declaration

{{< /rawhtml >}} ```C# public static void DropIfExists(string indexName, string tableName) ``` {{< rawhtml >}}

Parameters

Type	Name	Description
string	indexName	The index name to drop.
string	tableName	The table name the index is based on.

Implements

{{< /rawhtml >}}