ETLBox ETLBox

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
TypeDescription
System.String
Overrides

Methods

ListAll()

Runs sql code to determine all user database names.

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

The connection manager of the server you want to connect

Returns
TypeDescription
System.Collections.Generic.List<ObjectNameDescriptor>

A list of all user database names

Implements