DropIndexTask

Class DropIndexTask

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

Implements
Namespace: ETLBox.ControlFlow
Assembly: ETLBox.dll
Syntax
    public sealed class DropIndexTask : DropTask<IfIndexExistsTask>, ILoggableTask

Constructors

DropIndexTask()

Declaration
    public DropIndexTask()

DropIndexTask(string, string)

Declaration
    public DropIndexTask(string indexName, string tableName)
Parameters
TypeNameDescription
stringindexName
stringtableName

Properties

TN

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

Declaration
    public ObjectNameDescriptor TN { get; }
Property Value
TypeDescription
ObjectNameDescriptor

TableName

The table name on which the index is based on.

Declaration
    public string TableName { get; }
Property Value
TypeDescription
string

Methods

Drop(IConnectionManager, string, string)

Drops an index.

Declaration
    public static void Drop(IConnectionManager connectionManager, string indexName, string tableName)
Parameters
TypeNameDescription
IConnectionManagerconnectionManager

The connection manager of the database you want to connect

stringindexName

The index name to drop.

stringtableName

The table name the index is based on.

Drop(string, string)

Drops an index.

Declaration
    public static void Drop(string indexName, string tableName)
Parameters
TypeNameDescription
stringindexName

The index name to drop.

stringtableName

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
TypeNameDescription
IConnectionManagerconnectionManager

The connection manager of the database you want to connect

stringindexName

The index name to drop.

stringtableName

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
TypeNameDescription
stringindexName

The index name to drop.

stringtableName

The table name the index is based on.

Implements