/** * Generate the SQL to truncate a table. * * @param TableSchema $table Table instance. * @return array SQL statements to truncate a table. */ public function truncateTableSql(TableSchema $table) { $sql = sprintf('DROP TABLE %s CASCADE', $this->_driver->quoteIdentifier($table->name())); return [$sql]; }
/** * Generate the SQL to truncate a table. * * @param TableSchema $table Table instance. * @return array SQL statements to truncate a table. */ public function truncateTableSql(TableSchema $table) { return [sprintf('TRUNCATE TABLE `%s`', $table->name())]; }
/** * Generate the SQL to truncate a table. * * @param TableSchema $table Table instance. * @return array SQL statements to truncate a table. */ public function truncateTableSql(TableSchema $table) { $name = $this->_driver->quoteIdentifier($table->name()); $queries = [sprintf('DELETE FROM %s', $name)]; // Restart identity sequences $pk = $table->primaryKey(); if (count($pk) === 1) { $column = $table->column($pk[0]); if (in_array($column['type'], ['integer', 'biginteger'])) { $queries[] = sprintf('DBCC CHECKIDENT(%s, RESEED, 0)', $name); } } return $queries; }
/** * Generate the SQL to truncate a table. * * @param TableSchema $table Table instance. * @return array SQL statements to truncate a table. */ public function truncateTableSql(TableSchema $table) { $name = $table->name(); $sql = []; if ($this->hasSequences()) { $sql[] = sprintf('DELETE FROM sqlite_sequence WHERE name="%s"', $name); } $sql[] = sprintf('DELETE FROM "%s"', $name); return $sql; }