Class CleanUpSchemaTask

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

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

Constructors

CleanUpSchemaTask()

Declaration
    public CleanUpSchemaTask()

CleanUpSchemaTask(String)

Declaration
    public CleanUpSchemaTask(string schemaName)
Parameters
TypeNameDescription
System.StringschemaName

Properties

SchemaName

The name of the schema

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

Sql

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

Declaration
    public string Sql { get; }
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

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
TypeNameDescription
IConnectionManagerconnectionManager

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
TypeNameDescription
IConnectionManagerconnectionManager

The connection manager of the database you want to connect

System.StringschemaName

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
TypeNameDescription
System.StringschemaName

The name of the schema

Implements