How to drop all tables from database using yii

yii-drop-all-tables-from-database.php

<?php

$tables = Yii::app()->db->schema->getTableNames();
foreach ($tables as $table) {
    Yii::app()->db->createCommand()->dropTable($table);
}

how to import tables ?

Hey, don't forget about foreign_key_checks.

<?php 
Yii::app()->db->createCommand("SET foreign_key_checks = 0")->execute();
$tables = Yii::app()->db->schema->getTableNames();  
foreach ($tables as $table) {  
    Yii::app()->db->createCommand()->dropTable($table);  
}  
Yii::app()->db->createCommand("SET foreign_key_checks = 1")->execute();

Works a little better.

Neither one of your code should work. You need to add ->execute() after dropTable().

Also, app() doesn't exist... It should be $app.

Fixed code below, or view my Fork of this Gist:

<?php
Yii::$app->db->createCommand("SET foreign_key_checks = 0")->execute();
$tables = Yii::$app->db->schema->getTableNames();

foreach ($tables as $table) {
    Yii::$app->db->createCommand()->dropTable($table)->execute();
}

Yii::$app->db->createCommand("SET foreign_key_checks = 1")->execute();

Hope it helps 👍

oh comments

@pekhota, you're right, that works better
@wade, my code is from old yii 1.1. days