Class CleanUpSchemaTask
Tries to remove all database objects from the given schema(s). Currently only SqlServer and Oracle support this task.
Implements
Inherited Members
object.Equals(object)
object.Equals(object, object)
object.GetHashCode()
object.GetType()
object.MemberwiseClone()
object.ReferenceEquals(object, object)
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()
Examples
CleanUpSchemaTask.CleanUp("demo");CleanUpSchemaTask(string)
Declaration
public CleanUpSchemaTask(string schemaName)
Parameters
| Type | Name | Description |
|---|---|---|
| string | schemaName |
Examples
CleanUpSchemaTask.CleanUp("demo");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 |
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
| Type | Description |
|---|---|
| string |
Overrides
Methods
CleanUp()
Runs the sql to clean up the user schema. (Oracle only)
Declaration
public static void CleanUp()
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(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(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 |