GetTableListTask

Class GetTableListTask

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

Implements
Namespace: ETLBox.ControlFlow
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()

Methods

ListAll()

Runs sql code to determine all user database names.

Declaration
    public static List<ObjectNameDescriptor> ListAll()
Returns
TypeDescription
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
TypeNameDescription
IConnectionManagerconnectionManager

The connection manager of the server you want to connect

Returns
TypeDescription
List<ObjectNameDescriptor>

A list of all user database names

Implements