ISecurityConnection.Indexes

Syntax

Indexes(TableName: String): IDalIndexses;

Parameters

TableName. Table physical name in database.

Description

The Indexes property returns the cursor containing system information about indexes of 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 Main;
Var
    MB: IMetabase;
    DB: IDatabaseInstance;
    Cur: IDalIndexes;
    Field: IDalCursorField;
Begin
    MB := MetabaseClass.Active;
    DB := MB.ItemById("DB").Open(Null) As IDatabaseInstance;
    Cur := DB.Connection.Indexes("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 Main;

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 indexes of the specified table.