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.

3 methods override DatabaseSchema::fieldExists()

DatabaseSchema_mysql::fieldExists in includes/database/mysql/schema.inc

Check if a column exists in the given table.

DatabaseSchema_pgsql::fieldExists in includes/database/pgsql/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 ();
}

---