Class CleanUpSchemaTask

Tries to remove all database objects from the given schema(s). Currently only SqlServer and Oracle support this task.

Inheritance
System.Object
LoggableTask
ControlFlowTask
CleanUpSchemaTask
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 class CleanUpSchemaTask : ControlFlowTask, ILoggableTask
Examples
CleanUpSchemaTask.CleanUp("demo");

Constructors

CleanUpSchemaTask()

Declaration
public CleanUpSchemaTask()

CleanUpSchemaTask(String)

Declaration
public CleanUpSchemaTask(string schemaName)
Parameters
Type Name Description
System.String schemaName

Properties

SchemaName

The name of the schema

Declaration
public string SchemaName { get; set; }
Property Value
Type Description
System.String

Sql

The sql code that is used to clean up the schema.

Declaration
public string Sql { get; }
Property Value
Type Description
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; }
Property Value
Type Description
System.String
Overrides

Methods

CleanUp()

Runs the sql to clean up the user schema. (Oracle only)

Declaration
public static void CleanUp()

CleanUp(IConnectionManager)

Runs the sql to clean up the user schema. (Oracle only)

Declaration
public static void CleanUp(IConnectionManager connectionManager)
Parameters
Type Name Description
IConnectionManager connectionManager

The connection manager of the database you want to connect

CleanUp(IConnectionManager, String)

Runs the sql to clean up a schema.(Oracle and SqlServer only)

Declaration
public static void CleanUp(IConnectionManager connectionManager, string schemaName)
Parameters
Type Name Description
IConnectionManager connectionManager

The connection manager of the database you want to connect
System.String schemaName

The name of the schema

CleanUp(String)

Runs the sql to clean up a schema. (Oracle and SqlServer only)

Declaration
public static void CleanUp(string schemaName)
Parameters
Type Name Description
System.String schemaName

The name of the schema

Execute()

Runs the sql to clean up the schema

Declaration
public void Execute()

Implements