Class DropIndexTask
Drops an index. Use DropIfExists to drop an index only if it exists.
Implements
Inherited Members
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
| Type | Name | Description |
|---|---|---|
| string | indexName | |
| string | tableName |
Properties
TN
The formatted table name on which the index is based on.
Declaration
public ObjectNameDescriptor TN { get; }
Property Value
| Type | Description |
|---|---|
| ObjectNameDescriptor |
TableName
The table name on which the index is based on.
Declaration
public string TableName { get; }
Property Value
| Type | Description |
|---|---|
| string |
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 |
| string | indexName | The index name to drop. |
| 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 |
|---|---|---|
| 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
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 |
| 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
public static void DropIfExists(string indexName, string tableName)
Parameters
| Type | Name | Description |
|---|---|---|
| string | indexName | The index name to drop. |
| string | tableName | The table name the index is based on. |