ETLBox ETLBox

Class IfTableOrViewExistsTask

Checks if a table exists.

Inheritance
System.Object
LoggableTask
ControlFlowTask
IfExistsTask
IfTableOrViewExistsTask
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 IfTableOrViewExistsTask : IfExistsTask, ILoggableTask

Constructors

IfTableOrViewExistsTask()

Declaration
    public IfTableOrViewExistsTask()

IfTableOrViewExistsTask(IConnectionManager, String)

Declaration
    public IfTableOrViewExistsTask(IConnectionManager connectionManager, string tableName)
Parameters
TypeNameDescription
IConnectionManagerconnectionManager
System.StringtableName

IfTableOrViewExistsTask(String)

Declaration
    public IfTableOrViewExistsTask(string tableName)
Parameters
TypeNameDescription
System.StringtableName

Methods

IsExisting(IConnectionManager, String)

Ćhecks if the table or view exists

Declaration
    public static bool IsExisting(IConnectionManager connectionManager, string objectName)
Parameters
TypeNameDescription
IConnectionManagerconnectionManager

The connection manager of the database you want to connect

System.StringobjectName

The table or view name that you want to check for existence

Returns
TypeDescription
System.Boolean

True if the table or view exists

IsExisting(String)

Ćhecks if the table or view exists

Declaration
    public static bool IsExisting(string objectName)
Parameters
TypeNameDescription
System.StringobjectName

The table or view name that you want to check for existence

Returns
TypeDescription
System.Boolean

True if the table or view exists

Implements