ETLBox
Class CleanUpSchemaTask
Tries to remove all database objects from the given schema(s). Currently only SqlServer and Oracle support this task.
Implements
Inherited Members
Namespace: ETLBox.ControlFlow
Assembly: ETLBox.dll
Syntax
public sealed class CleanUpSchemaTask : ControlFlowTask, ILoggableTaskExamples
CleanUpSchemaTask.CleanUp("demo");Constructors
CleanUpSchemaTask()
Declaration
public CleanUpSchemaTask()CleanUpSchemaTask(string)
Declaration
public CleanUpSchemaTask(string schemaName)Parameters
| Type | Name | Description |
|---|---|---|
| string | schemaName |
Properties
SchemaName
The name of the schema
Declaration
public string SchemaName { get; set; }Property Value
| Type | Description |
|---|---|
| string |
Sql
The sql code that is used to clean up the schema.
Declaration
public string Sql { get; }Property Value
| Type | Description |
|---|---|
| string |
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.
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 |
| 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 |
|---|---|---|
| string | schemaName | The name of the schema |