ETLBox ETLBox

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 sealed class DropIndexTask : DropTask<IfIndexExistsTask>, ILoggableTask

Constructors

DropIndexTask()

Declaration
    public DropIndexTask()

DropIndexTask(String, String)

Declaration
    public DropIndexTask(string indexName, string tableName)
Parameters
TypeNameDescription
System.StringindexName
System.StringtableName

Properties

TableName

The table name on which the index is based on.

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

TN

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

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

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

System.StringindexName

The index name to drop.

System.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
System.StringindexName

The index name to drop.

System.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

System.StringindexName

The index name to drop.

System.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
System.StringindexName

The index name to drop.

System.StringtableName

The table name the index is based on.

Implements