Method Msql.msql()->list_index()

Method list_index

array list_index(string tablename, string indexname)

Description

This function returns an array describing the index structure for the given table and index name, as defined by the non-standard SQL query 'create index' (see the mSQL documentation for further informations). More than one index can be created for a table. There's currently NO way to have a listing of the indexes defined for a table (blame it on the mSQL API).

Note

This function is available if you're using mSQL version 2 or later.

This function is not part of the standard interface, so it is not available through the Sql.Sql interface, but only through Sql.msql and Msql.msql programs.