W3cubDocs

/Drupal 8

public function Schema::fieldExists

public Schema::fieldExists($table, $column)

Check if a column exists in the given table.

Parameters

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

$name: The name of the column.

Return value

TRUE if the given column exists, otherwise FALSE.

File

core/lib/Drupal/Core/Database/Schema.php, line 244

Class

Schema
Provides a base implementation for Database Schema.

Namespace

Drupal\Core\Database

Code

public function fieldExists($table, $column) {
  $condition = $this->buildTableNameCondition($table);
  $condition->condition('column_name', $column);
  $condition->compile($this->connection, $this);
  // Normally, we would heartily discourage the use of string
  // concatenation for conditionals like this however, we
  // couldn't use db_select() here because it would prefix
  // information_schema.tables and the query would fail.
  // Don't use {} around information_schema.columns table.
  return (bool) $this->connection->query("SELECT 1 FROM information_schema.columns WHERE " . (string) $condition, $condition->arguments())->fetchField();
}

© 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!Schema.php/function/Schema::fieldExists/8.1.x