public function Schema::indexExists

Same name in this branch
  1. 9.x drupal/core/lib/Drupal/Core/Database/Schema.php \Drupal\Core\Database\Schema::indexExists()
  2. 9.x drupal/core/lib/Drupal/Core/Database/Driver/mysql/Schema.php \Drupal\Core\Database\Driver\mysql\Schema::indexExists()
  3. 9.x drupal/core/lib/Drupal/Core/Database/Driver/sqlite/Schema.php \Drupal\Core\Database\Driver\sqlite\Schema::indexExists()
  4. 9.x drupal/core/lib/Drupal/Core/Database/Driver/pgsql/Schema.php \Drupal\Core\Database\Driver\pgsql\Schema::indexExists()

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

6 calls to Schema::indexExists()
Schema::addIndex in drupal/core/lib/Drupal/Core/Database/Driver/mysql/Schema.php
Add an index.
Schema::addPrimaryKey in drupal/core/lib/Drupal/Core/Database/Driver/mysql/Schema.php
Add a primary key.
Schema::addUniqueKey in drupal/core/lib/Drupal/Core/Database/Driver/mysql/Schema.php
Add a unique key.
Schema::dropIndex in drupal/core/lib/Drupal/Core/Database/Driver/mysql/Schema.php
Drop an index.
Schema::dropPrimaryKey in drupal/core/lib/Drupal/Core/Database/Driver/mysql/Schema.php
Drop the primary key.

... See full list

File

drupal/core/lib/Drupal/Core/Database/Driver/mysql/Schema.php, line 394
Definition of Drupal\Core\Database\Driver\mysql\Schema

Class

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 = '{$name}'")
    ->fetchAssoc();
  return isset($row['Key_name']);
}