db_drop_index

db_drop_index(&$ret, $table, $name)
files/drupal-6.7/includes/database.pgsql.inc, line 840

Drop an index.

$ret Array to which query results will be added.

$table The table to be altered.

$name The name of the index.

Name	Description
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.
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.

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

CCK API a.d.o. for CCK