获取yii中的所有表名 [英] Get all table names in yii

问题描述

如何在yii中获取所有表名?

How to get all table names in yii?

mySQL中的sql查询为SHOW TABLES. 我试过了:

The sql query in mySQL is SHOW TABLES. I tried:

$sql = 'SHOW TABLES';
$tables = Yii::app()->db
         ->createCommand($sql)
         ->queryAll();
print_r($tables);

它抛出一个错误:

CDbCommand failed to execute the SQL statement:
CDbCommand failed to prepare the SQL statement:
SQLSTATE[HY000]: General error: 1 near "SHOW": syntax error.
The SQL statement executed was: SHOW TABLES 

推荐答案

尝试以下方法:

$connection = Yii::app()->db;//get connection
$dbSchema = $connection->schema;
//or $connection->getSchema();
$tables = $dbSchema->getTables();//returns array of tbl schema's
foreach($tables as $tbl)
{
    echo $tbl->rawName, ':<br/>', implode(', ', $tbl->columnNames), '<br/>';
}

引用:: 查看全文