Class TruncateTableTask

Truncates a table.

Inheritance

object

LoggableTask

ControlFlowTask

TruncateTableTask

Implements

ILoggableTask

Inherited Members

ControlFlowTask.ConnectionManager

ControlFlowTask.ConnectionType

ControlFlowTask.QB

ControlFlowTask.QE

LoggableTask.TaskType

LoggableTask.TaskName

LoggableTask.DisableLogging

LoggableTask.LogThreshold

LoggableTask.TaskHash

LoggableTask.LogInstance

LoggableTask.ParentTask

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.ReferenceEquals(object, object)

object.ToString()

Namespace: ETLBox.ControlFlow

Assembly: ETLBox.dll

Syntax

{{< /rawhtml >}} ```C# public sealed class TruncateTableTask : ControlFlowTask, ILoggableTask ``` {{< rawhtml >}}

Examples

TruncateTableTask.Truncate("demo.table1");

Constructors

TruncateTableTask()

Declaration

{{< /rawhtml >}} ```C# public TruncateTableTask() ``` {{< rawhtml >}}

TruncateTableTask(string)

Declaration

{{< /rawhtml >}} ```C# public TruncateTableTask(string tableName) ``` {{< rawhtml >}}

Parameters

Type	Name	Description
string	tableName	Sets the TableName

Properties

Sql

Sql code that is used when the task is executed.

Declaration

{{< /rawhtml >}} ```C# public string Sql { get; } ``` {{< rawhtml >}}

Property Value

Type	Description
string

TN

The formatted table table name

Declaration

{{< /rawhtml >}} ```C# public ObjectNameDescriptor TN { get; } ``` {{< rawhtml >}}

Property Value

Type	Description
ObjectNameDescriptor

TableName

Name of the table that should be truncated

Declaration

{{< /rawhtml >}} ```C# public string TableName { get; set; } ``` {{< rawhtml >}}

Property Value

Type	Description
string

Methods

Truncate(IConnectionManager, string)

Execute a table truncation

Declaration

{{< /rawhtml >}} ```C# public static void Truncate(IConnectionManager connection, string tableName) ``` {{< rawhtml >}}

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

{{< /rawhtml >}} ```C# public static void Truncate(string tableName) ``` {{< rawhtml >}}

Parameters

Type	Name	Description
string	tableName	Table that should be truncated

TruncateAsync(IConnectionManager, string)

Declaration

{{< /rawhtml >}} ```C# public static void TruncateAsync(IConnectionManager connection, string tableName) ``` {{< rawhtml >}}

Parameters

Type	Name	Description
IConnectionManager	connection
string	tableName

Implements

ILoggableTask