Class TruncateTableTask
Truncates a table.
Implements
Inherited Members
object.Equals(object)
object.Equals(object, object)
object.GetHashCode()
object.GetType()
object.MemberwiseClone()
object.ReferenceEquals(object, object)
object.ToString()
Namespace: ETLBox.ControlFlow.Tasks
Assembly: ETLBox.dll
Syntax
public sealed class TruncateTableTask : ControlFlowTask, ILoggableTask
Examples
TruncateTableTask.Truncate("demo.table1");Constructors
TruncateTableTask()
Declaration
public TruncateTableTask()
Examples
TruncateTableTask.Truncate("demo.table1");TruncateTableTask(string)
Declaration
public TruncateTableTask(string tableName)
Parameters
| Type | Name | Description |
|---|---|---|
| string | tableName | Sets the TableName |
Properties
Sql
Sql code that is used when the task is executed.
Declaration
public string Sql { get; }
Property Value
| Type | Description |
|---|---|
| string |
TableName
Name of the table that should be truncated
Declaration
public string TableName { get; set; }
Property Value
| Type | Description |
|---|---|
| string |
TaskName
A name to identify the task or component. Every component or task comes with a default name that can be overwritten.
Declaration
public override string TaskName { get; set; }
Property Value
| Type | Description |
|---|---|
| string |
Overrides
TN
The formatted table table name
Declaration
public ObjectNameDescriptor TN { get; }
Property Value
| Type | Description |
|---|---|
| ObjectNameDescriptor |
Methods
Truncate(IConnectionManager, string)
Execute a table truncation
Declaration
public static void Truncate(IConnectionManager connection, string tableName)
Parameters
| Type | Name | Description |
|---|---|---|
| IConnectionManager | connection | Database connection manager to connect with the database |
| string | tableName | Table name that should be truncated |
Truncate(string)
Execute a table truncation
Declaration
public static void Truncate(string tableName)
Parameters
| Type | Name | Description |
|---|---|---|
| string | tableName | Table that should be truncated |
TruncateAsync(IConnectionManager, string)
Declaration
public static void TruncateAsync(IConnectionManager connection, string tableName)
Parameters
| Type | Name | Description |
|---|---|---|
| IConnectionManager | connection | |
| string | tableName |
Examples
TruncateTableTask.Truncate("demo.table1");