SMF Function List

Main Menu

Navigation

Returns information about the indexes in a table

mixed smf_db_list_indexes (string $table_name[, bool $detail[, array $parameters]])

Expected type: String
Description: The name of the table to get indexes for

Expected type: Boolean
Description: Whether or not to return detailed index info. Defaults to false.

Expected type: Array
Description: An array of parameters

Array Elements of $parameters
Key	Optional	Expected type	Description
no_prefix	yes	Boolean	If true, SMF won't add the db_prefix to the table name

Expected type: Mixed
Description: An array of index names or an array of arrays containing detailed info about each index

Possible types
Allowed values	Description
Array	An array of index names
Array of arrays	An array of arrays containing detailed index info (keys are index names)

Returns an array of index names if $detail is false
Returns an array of index_name => array(details) pairs if $detail is true (keys in details array: 'key_name' (index name, 'primary' for primary keys), 'type' (index type: 'primary', 'unique', 'fulltext' or 'index') and 'columns' (array of column names (includes "sub-part" if applicable))