public function Schema::indexExists in Drupal 10

Same name in this branch

1. 10 core/lib/Drupal/Core/Database/Schema.php \Drupal\Core\Database\Schema::indexExists()
2. 10 core/modules/sqlite/src/Driver/Database/sqlite/Schema.php \Drupal\sqlite\Driver\Database\sqlite\Schema::indexExists()
3. 10 core/modules/pgsql/src/Driver/Database/pgsql/Schema.php \Drupal\pgsql\Driver\Database\pgsql\Schema::indexExists()
4. 10 core/modules/mysql/src/Driver/Database/mysql/Schema.php \Drupal\mysql\Driver\Database\mysql\Schema::indexExists()
5. 10 core/tests/fixtures/database_drivers/module/corefake/src/Driver/Database/corefakeWithAllCustomClasses/Schema.php \Drupal\corefake\Driver\Database\corefakeWithAllCustomClasses\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

7 calls to Schema::indexExists()

Schema::addField in core/modules/mysql/src/Driver/Database/mysql/Schema.php

Add a new field to a table.

Schema::addIndex in core/modules/mysql/src/Driver/Database/mysql/Schema.php

Add an index.

Schema::addPrimaryKey in core/modules/mysql/src/Driver/Database/mysql/Schema.php

Add a primary key.

Schema::addUniqueKey in core/modules/mysql/src/Driver/Database/mysql/Schema.php

Add a unique key.

Schema::dropIndex in core/modules/mysql/src/Driver/Database/mysql/Schema.php

Drop an index.

... See full list

File

core/modules/mysql/src/Driver/Database/mysql/Schema.php, line 489

Class

Schema

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

Namespace

Drupal\mysql\Driver\Database\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']);
}