Same name in this branch
  1. 6.x includes/database.pgsql.inc \db_column_exists()
  2. 6.x includes/database.mysqli.inc \db_column_exists()
  3. 6.x includes/database.mysql.inc \db_column_exists()

Check if a column exists in the given table.

Parameters

$table: The name of the table.

$column: The name of the column.

Return value

TRUE if the column exists, and FALSE if the column does not exist.

Related topics

Database abstraction layer
Allow the use of different database servers using the same code base.
1 call to db_column_exists()
system_update_6051 in modules/system/system.install
Create a signature_format column.

File

includes/database.mysql.inc, line 370
Database interface code for MySQL database servers.

Code

function db_column_exists($table, $column) {
  return (bool) db_fetch_object(db_query("SHOW COLUMNS FROM {" . db_escape_table($table) . "} LIKE '" . db_escape_table($column) . "'"));
}