ETLBox
Class GetViewListTask
Returns a list of all tables in the currently connected database.
Make sure to connect with the correct permissions!
Implements
Inherited Members
Namespace: ETLBox.ControlFlow
Assembly: ETLBox.dll
Syntax
public sealed class GetViewListTask : GetListTask, ILoggableTaskExamples
List<ETLBox.Helper.ObjectNameDescriptor> allviews = GetViewListTask.List();
foreach (var on in allviews) {
Console.WriteLine("Schema:" + on.UnquotatedSchemaName);
Console.WriteLine("ViewName:" + on.UnquotatedObjectName);
Console.WriteLine("Full qualified name:" + on.QuotatedFullName);
}Constructors
GetViewListTask()
Declaration
public GetViewListTask()Methods
ListAll()
Runs sql code to determine all user database names.
Declaration
public static List<ObjectNameDescriptor> ListAll()Returns
| Type | Description |
|---|---|
| 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 |
|---|---|
| List<ObjectNameDescriptor> | A list of all user database names |