You are here

public function DatabaseSchema::fieldExists in Drupal 7

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.

5 calls to DatabaseSchema::fieldExists()
DatabaseSchema_pgsql::addField in includes/database/pgsql/schema.inc
Add a new field to a table.
DatabaseSchema_pgsql::changeField in includes/database/pgsql/schema.inc
Change a field definition.
DatabaseSchema_pgsql::dropField in includes/database/pgsql/schema.inc
Drop a field.
DatabaseSchema_pgsql::fieldSetDefault in includes/database/pgsql/schema.inc
Set the default value for a field.
DatabaseSchema_pgsql::fieldSetNoDefault in includes/database/pgsql/schema.inc
Set a field to have no default value.
2 methods override DatabaseSchema::fieldExists()
DatabaseSchema_mysql::fieldExists in includes/database/mysql/schema.inc
Check if a column exists in the given table.
DatabaseSchema_sqlite::fieldExists in includes/database/sqlite/schema.inc
Check if a column exists in the given table.

File

includes/database/schema.inc, line 428

Class

DatabaseSchema
Base class for database schema definitions.

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();
}