db_truncate

7 database.inc	`db_truncate($table, array $options = array())`
8 database.inc	`db_truncate($table, array $options = array())`

Returns a new TruncateQuery object for the active database.

Parameters

$table: The table from which to delete.

$options: An array of options to control how the query operates.

Return value

TruncateQuery A new TruncateQuery object for this connection.

7 calls to db_truncate()

File

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

Code

function db_truncate($table, array $options = array()) {
  if (empty($options['target']) || $options['target'] == 'slave') {
    $options['target'] = 'default';
  }
  return Database::getConnection($options['target'])->truncate($table, $options);
}

Comments

use execute() to make the truncate happen

Posted by drupalshrek on February 13, 2012 at 5:05pm

In order to actually make the truncate happen, you have to call execute on the returned TruncateQuery object, e.g.:

<?php
  $result = db_truncate('vchess_stats')->execute();
  $result = db_truncate('vchess_games')->execute();
  $result = db_truncate('vchess_moves')->execute();
?>