Class GetTableListTask

Returns a list of all tables in the currently connected database.
Make sure to connect with the correct permissions!

Inheritance
System.Object
LoggableTask
ControlFlowTask
GetListTask
GetTableListTask
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 GetTableListTask : GetListTask, ILoggableTask
Examples
    
List<ETLBox.Helper.ObjectNameDescriptor> alltables = GetTableListTask.List();
foreach (var on in alltables) {
    Console.WriteLine("Schema:" + on.UnquotatedSchemaName);
    Console.WriteLine("TableName:" + on.UnquotatedObjectName);
    Console.WriteLine("Full qualified name:" + on.QuotatedFullName);
}

Constructors

GetTableListTask()

Declaration
public GetTableListTask()

Properties

TaskName

Declaration
public override string TaskName { get; set; }
Property Value
Type Description
System.String
Overrides

Methods

ListAll()

Runs sql code to determine all user database names.

Declaration
public static List<ObjectNameDescriptor> ListAll()
Returns
Type Description
System.Collections.Generic.List<ObjectNameDescriptor>

A list of all user database names

ListAll(IConnectionManager)

Runs sql code to determine all user database names.

Declaration
public static List<ObjectNameDescriptor> ListAll(IConnectionManager connectionManager)
Parameters
Type Name Description
IConnectionManager connectionManager

The connection manager of the server you want to connect
Returns
Type Description
System.Collections.Generic.List<ObjectNameDescriptor>

A list of all user database names

Implements