Extracted from Pike v7.3 release 16 at 2002-03-05.
pike.roxen.com
[Top]
Msql
Msql.msql
· affected_rows()
· create()
· create_db()
· drop_db()
· error()
· host_info()
· list_dbs()
· list_fields()
· list_index()
· list_tables()
· query()
· reload_acl()
· select_db()
· server_info()
· shutdown()
previousMsql.msql()->list_fields()
Msql.msql()->list_tables()next

Method Msql.msql()->list_index()

Method list_index

array Msql.msql()->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 availible if you're using mSQL version 2 or later.

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