IDtObjectMetaData.Tables

Syntax

Tables: Array;

Description

The Tables method returns string array, that contains names of the data source or consumer tables.

Example

Executing the example requires that the repository contains an ETL task with the Etl identifier. The first task object is any data source, that uses drivers OLE DB for connection. For example, import from Access.

Sub Main;

Var

MB: IMetabase;

Task: IEtlTask;

Provider: IEtlPlainDataProvider;

MetaData: IDtObjectMetaData;

Arr, Arr1: Array Of String;

s: String;

Begin

MB := MetabaseClass.Active;

Task := MB.ItemById("ETL").Bind As IEtlTask;

Provider := Task.Item(0) As IEtlPlainDataProvider;

MetaData := Provider.Provider As IDtObjectMetaData;

Arr := MetaData.Tables;

Arr1 := MetaData.Views;

Debug.WriteLine("Table");

For Each s In Arr Do

Debug.WriteLine(s);

End For;

Debug.WriteLine("View");

For Each s In Arr1 Do

Debug.WriteLine(s);

End For;

End Sub Main;

After executing the example the development environment console displays a list of tables and views, kept in the object, to which data provider of the ETL task is set.