Class TruncateTableTask

Truncates a table.

Inheritance
System.Object
TruncateTableTask
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 TruncateTableTask : ControlFlowTask, ILoggableTask
Examples
TruncateTableTask.Truncate("demo.table1");

Constructors

TruncateTableTask()

Declaration
    public TruncateTableTask()

TruncateTableTask(String)

Declaration
    public TruncateTableTask(string tableName)
Parameters
TypeNameDescription
System.StringtableName

Sets the TableName

Properties

Sql

Sql code that is used when the task is executed.

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

TableName

Name of the table that should be truncated

Declaration
    public string TableName { get; set; }
Property Value
TypeDescription
System.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
TypeDescription
System.String
Overrides

TN

The formatted table table name

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

Methods

Truncate(IConnectionManager, String)

Execute a table truncation

Declaration
    public static void Truncate(IConnectionManager connection, string tableName)
Parameters
TypeNameDescription
IConnectionManagerconnection

Database connection manager to connect with the database

System.StringtableName

Table name that should be truncated

Truncate(String)

Execute a table truncation

Declaration
    public static void Truncate(string tableName)
Parameters
TypeNameDescription
System.StringtableName

Table that should be truncated

Implements