Home » API reference » Drupal 6 » database.pgsql.inc

db_drop_index

6 database.mysql-common.inc db_drop_index(&$ret, $table, $name)
6 database.pgsql.inc db_drop_index(&$ret, $table, $name)
7 database.inc db_drop_index($table, $name)
8 database.inc db_drop_index($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.

130 functions call db_drop_index()

File

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

Code

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