ISecurityConnection.Columns

Syntax

Columns(TableName: String): IDalColumns;

Parameters

TableName. Physical name of the table, which field information should be obtained.

Description

The Columns property returns the cursor containing system information about table fields, 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: IDalColumns;
    Field: IDalCursorField;
Begin
    MB := MetabaseClass.Active;
    DB := MB.ItemById("DB").Open(Null) As IDatabaseInstance;
    Cur := DB.Connection.Columns("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 database is set, is established. The development environment console will display system information about the specified table.