Indexes(TableName: String): IDalIndexses;
TableName - a physical name of the table in DB.
The Indexes property returns the cursor, containing system information about indexes of the table, which physical name is passed by the TableName parameter.
Executing the example requires that the repository contains a database with the BD identifier.
Sub Main;
Var
MB: IMetabase;
DB: IDatabaseInstance;
Cur: IDalIndexes;
Field: IDalCursorField;
Begin
MB := MetabaseClass.Active;
DB := MB.ItemById("BD").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 DB server, on which the BD repository database is set, is performed. System information about indexes of the table with the physical name "Table_1", if there is such on the server, is displayed in a development environment console.
See also: