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, ILoggableTask
Examples
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 |