Check table exists

php mysql yii2 dao
iGbanam picture iGbanam · Jul 28, 2015 · Viewed 8.8k times · Source

I need to check if a table exists in a database. I currently develop using Yii2.

My case is a bit different from this question because the table to be checked is not (and can not be) a model.

I have tried (new \yii\db\Query())->select('*')->from($mysticTable)->exists());

The above throws a yii\db\Exception because, according to question linked above, the yii\db\Query() class tries to ->queryScalar() when asked if ->exists(). Invariably, this method checks if the result-set exists.

How do I check if a table exists?

Answer

arogachev picture arogachev · Jul 28, 2015

For Yii2 you can use:

$tableSchema = Yii::$app->db->schema->getTableSchema('tableName');

If the table does not exist, it will return null, so you can check returned value for being null:

if ($tableSchema === null) {
    // Table does not exist
}

You can find this method in official docs here.

Related questions

Yii2 How to perform where AND or OR condition grouping?

I am new to Yii-2 framework. How can i achieve following query in Yii-2 framework using activeQuery and models. SELECT * FROM users AS u WHERE u.user_id IN(1,5,8) AND (u.status = 1 OR u.verified = 1) OR (u.social_account = 1 AND …

Read More
How to count and group by in yii2

I would like to generate following query using yii2: SELECT COUNT(*) AS cnt FROM lead WHERE approved = 1 GROUP BY promoter_location_id, lead_type_id I have tried: $leadsCount = Lead::find() ->where('approved = 1') ->groupBy(['promoter_…

Read More
Performing raw SQL queries in Yii2?

I have written the below queries as I migrate my PHP website to the Yii2 framework. I want to add them to my controller so as to display the top 10 bets won. I have tried going through many Yii2 database …

Read More