Class DropIndexTask
Drops an index. Use DropIfExists to drop an index only if it exists.
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
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. |