public function DatabaseConnection::prefixTables

7.x public DatabaseConnection::prefixTables($sql)

Appends a database prefix to all tables in a query.

Queries sent to Drupal should wrap all table names in curly brackets. This function searches for this syntax and adds Drupal's table prefix to all tables, allowing Drupal to coexist with other systems in the same database and/or schema if necessary.


$sql: A string containing a partial or entire SQL query.

Return value

The properly-prefixed string.

3 calls to DatabaseConnection::prefixTables()
DatabaseConnection::makeSequenceName in drupal/includes/database/
Creates the appropriate sequence name for a given table and serial field.
DatabaseConnection::prepareQuery in drupal/includes/database/
Prepares a query string and returns the prepared statement.
DatabaseConnection_sqlite::prepareQuery in drupal/includes/database/sqlite/
Prepares a query string and returns the prepared statement.


drupal/includes/database/, line 447
Core systems for the database layer.


Base Database API class.


public function prefixTables($sql) {
  return str_replace($this->prefixSearch, $this->prefixReplace, $sql);