ISecurityConnection.Tables

Syntax

Tables(Value: String): IDalTables;

Parameters

Value. table physical name in database.

Description

The Tables property returns the cursor containing system information about the table, which physical name is sent by input parameter.

Example

Executing the example requires that the repository contains a database with the DB identifier. The database server, on which the database is set up, contains a table with the Table_1 physical name.

Sub UserProc;
Var
    MB: IMetabase;
    DB: IDatabaseInstance;
    Cur: IDalTables;
    Field: IDalCursorField;
Begin
    MB := MetabaseClass.Active;
    DB := MB.ItemById("DB").Open(Null) As IDatabaseInstance;
    Cur := DB.Connection.Tables("Table_1");
    While Not Cur.Eof Do
        For Each Field In Cur.Fields Do
            Debug.WriteLine(Field.Name + " " + Field.Value);
        End For;
        Debug.WriteLine("");
        Cur.Next;
    End While;
    Cur.Close;
End Sub UserProc;

After executing the example, connection to the database server, on which the database is set up, established. The development environment console will display system information about the specified table.