Commands to Drop Database Tables? (and create as well...)

Archives Yii 1.0.x Discussions
1

Hello -

Just wondering if there is any Yii commands to create or drop database tables in my application?

Basically, when a user selects an option, I would like to create a table, and then when the user is finished using it, i would like to record the results, write them elsewhere, and then drop the table

Any help would be appreciated

Thanks

2

create/drop table are standard SQLs. You can use Yii::app()->db->createCommand($sql)->execute(); to run them.

3

thanks man -

will give it a shot