7.x database.inc 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 includes/database/database.inc
Creates the appropriate sequence name for a given table and serial field.
DatabaseConnection::prepareQuery in includes/database/database.inc
Prepares a query string and returns the prepared statement.
DatabaseConnection_sqlite::prepareQuery in includes/database/sqlite/database.inc
Prepares a query string and returns the prepared statement.


includes/database/database.inc, line 461
Core systems for the database layer.


Base Database API class.


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


VeronicaDurden’s picture

Looking to minimize Theft and Fraud.