Class DropIndexTask

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

Inheritance
System.Object
LoggableTask
ControlFlowTask
DropTask<IfIndexExistsTask>
DropIndexTask
Implements
Inherited Members
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 DropIndexTask : DropTask<IfIndexExistsTask>, ILoggableTask

Constructors

DropIndexTask()

Declaration
public DropIndexTask()

DropIndexTask(String, String)

Declaration
public DropIndexTask(string indexName, string tableName)
Parameters
Type Name Description
System.String indexName
System.String tableName

Properties

TableName

The table name on which the index is based on.

Declaration
public string TableName { get; }
Property Value
Type Description
System.String

TN

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

Declaration
public ObjectNameDescriptor TN { get; }
Property Value
Type Description
ObjectNameDescriptor

Methods

Drop(IConnectionManager, String, String)

Drops an index.

Declaration
public static void Drop(IConnectionManager connectionManager, string indexName, string tableName)
Parameters
Type Name Description
IConnectionManager connectionManager

The connection manager of the database you want to connect
System.String indexName

The index name to drop.
System.String tableName

The table name the index is based on.

Drop(String, String)

Drops an index.

Declaration
public static void Drop(string indexName, string tableName)
Parameters
Type Name Description
System.String indexName

The index name to drop.
System.String tableName

The table name the index is based on.

DropIfExists(IConnectionManager, String, String)

Drops an index if the index exists.

Declaration
public static void DropIfExists(IConnectionManager connectionManager, string indexName, string tableName)
Parameters
Type Name Description
IConnectionManager connectionManager

The connection manager of the database you want to connect
System.String indexName

The index name to drop.
System.String tableName

The table name the index is based on.

DropIfExists(String, String)

Drops an index if the index exists.

Declaration
public static void DropIfExists(string indexName, string tableName)
Parameters
Type Name Description
System.String indexName

The index name to drop.
System.String tableName

The table name the index is based on.

Implements