function db_drop_index

7.x database.inc	`db_drop_index($table, $name)`
6.x database.pgsql.inc	`db_drop_index(&$ret, $table, $name)`
6.x database.mysql-common.inc	`db_drop_index(&$ret, $table, $name)`

Drop an index.

Parameters

$ret: Array to which query results will be added.

$table: The table to be altered.

$name: The name of the index.

Related topics

Schema API: A Drupal schema definition is an array structure representing one or more tables and their related keys and indexes. A schema is defined by hook_schema(), which usually lives in a modulename.install file.

10 calls to db_drop_index()

locale_update_6004 in drupal-6.x/modules/locale/locale.install: Fix remaining inconsistent indexes.
system_update_6019 in drupal-6.x/modules/system/system.install: Reconcile small differences in the previous, manually created mysql and pgsql schemas so they are the same and can be represented by a single schema structure.
system_update_6022 in drupal-6.x/modules/system/system.install: Update files tables to associate files to a uid by default instead of a nid. Rename file_revisions to upload since it should only be used by the upload module used by upload to link files to nodes.
system_update_6023 in drupal-6.x/modules/system/system.install
system_update_6025 in drupal-6.x/modules/system/system.install: Increase the maximum length of node titles from 128 to 255.

... See full list

File

drupal-6.x/includes/database.pgsql.inc, line 827: Database interface code for PostgreSQL database servers.

Code

function db_drop_index(&$ret, $table, $name) {
  $name = '{' . $table . '}_' . $name . '_idx';
  $ret[] = update_sql('DROP INDEX ' . $name);
}