You are here

public function Schema::dropField in Drupal 9

Same name in this branch
  1. 9 core/lib/Drupal/Core/Database/Schema.php \Drupal\Core\Database\Schema::dropField()
  2. 9 core/lib/Drupal/Core/Database/Driver/sqlite/Schema.php \Drupal\Core\Database\Driver\sqlite\Schema::dropField()
  3. 9 core/lib/Drupal/Core/Database/Driver/pgsql/Schema.php \Drupal\Core\Database\Driver\pgsql\Schema::dropField()
  4. 9 core/lib/Drupal/Core/Database/Driver/mysql/Schema.php \Drupal\Core\Database\Driver\mysql\Schema::dropField()
  5. 9 core/tests/fixtures/database_drivers/module/corefake/src/Driver/Database/corefakeWithAllCustomClasses/Schema.php \Drupal\corefake\Driver\Database\corefakeWithAllCustomClasses\Schema::dropField()
Same name and namespace in other branches
  1. 8 core/lib/Drupal/Core/Database/Driver/mysql/Schema.php \Drupal\Core\Database\Driver\mysql\Schema::dropField()

Drop a field.

Parameters

$table: The table to be altered.

$field: The field to be dropped.

Return value

TRUE if the field was successfully dropped, FALSE if there was no field by that name to begin with.

Overrides Schema::dropField

File

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

Class

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

Namespace

Drupal\Core\Database\Driver\mysql

Code

public function dropField($table, $field) {
  if (!$this
    ->fieldExists($table, $field)) {
    return FALSE;
  }

  // When dropping a field that is part of a composite primary key MySQL
  // automatically removes the field from the primary key, which can leave the
  // table in an invalid state. MariaDB 10.2.8 requires explicitly dropping
  // the primary key first for this reason. We perform this deletion
  // explicitly which also makes the behavior on both MySQL and MariaDB
  // consistent with PostgreSQL.
  // @see https://mariadb.com/kb/en/library/alter-table
  $primary_key = $this
    ->findPrimaryKeyColumns($table);
  if (count($primary_key) > 1 && in_array($field, $primary_key, TRUE)) {
    $this
      ->dropPrimaryKey($table);
  }
  $this->connection
    ->query('ALTER TABLE {' . $table . '} DROP `' . $field . '`');
  return TRUE;
}