W3cubDocs

/Drupal 8

public function Schema::indexExists

public Schema::indexExists($table, $name)

Checks if an index exists in the given table.

Parameters

$table: The name of the table in drupal (no prefixing).

$name: The name of the index in drupal (no prefixing).

Return value

TRUE if the given index exists, otherwise FALSE.

Overrides Schema::indexExists

File

core/lib/Drupal/Core/Database/Driver/mysql/Schema.php, line 445

Class

Schema
MySQL implementation of \Drupal\Core\Database\Schema.

Namespace

Drupal\Core\Database\Driver\mysql

Code

public function indexExists($table, $name) {
  // Returns one row for each column in the index. Result is string or FALSE.
  // Details at http://dev.mysql.com/doc/refman/5.0/en/show-index.html
  $row = $this->connection->query('SHOW INDEX FROM {' . $table . '} WHERE key_name = ' . $this->connection->quote($name))->fetchAssoc();
  return isset($row['Key_name']);
}

© 2001–2016 by the original authors
Licensed under the GNU General Public License, version 2 and later.
Drupal is a registered trademark of Dries Buytaert.
https://api.drupal.org/api/drupal/core!lib!Drupal!Core!Database!Driver!mysql!Schema.php/function/Schema::indexExists/8.1.x