| public findTableNames ( string $schema = '' ) : array | ||
| $schema | string | the schema of the tables. Defaults to empty string, meaning the current or default schema. If not empty, the returned table names will be prefixed with the schema name. |
| Résultat | array | all table names in the database. |
public function findTableNames($schema = '')
{
if ($schema === '') {
return $this->getDbConnection()->createCommand('SHOW TABLES')->queryColumn();
}
$names = $this->getDbConnection()->createCommand('SHOW TABLES FROM ' . $this->quoteTableName($schema))->queryColumn();
foreach ($names as &$name) {
$name = $schema . '.' . $name;
}
return $names;
}