public function DatabaseSchema::fieldExists
7.x schema.inc | public DatabaseSchema::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.
5 calls to DatabaseSchema::fieldExists()
- DatabaseSchema_pgsql::addField in drupal-7.x/
includes/ database/ pgsql/ schema.inc - Add a new field to a table.
- DatabaseSchema_pgsql::changeField in drupal-7.x/
includes/ database/ pgsql/ schema.inc - Change a field definition.
- DatabaseSchema_pgsql::dropField in drupal-7.x/
includes/ database/ pgsql/ schema.inc - Drop a field.
- DatabaseSchema_pgsql::fieldSetDefault in drupal-7.x/
includes/ database/ pgsql/ schema.inc - Set the default value for a field.
- DatabaseSchema_pgsql::fieldSetNoDefault in drupal-7.x/
includes/ database/ pgsql/ schema.inc - Set a field to have no default value.
2 methods override DatabaseSchema::fieldExists()
- DatabaseSchema_mysql::fieldExists in drupal-7.x/
includes/ database/ mysql/ schema.inc - Check if a column exists in the given table.
- DatabaseSchema_sqlite::fieldExists in drupal-7.x/
includes/ database/ sqlite/ schema.inc - Check if a column exists in the given table.
File
- drupal-7.x/
includes/ database/ schema.inc, line 354 - Generic Database schema code.
Class
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();
}