public function getTables() { $tables = []; foreach ($this->connection->query('SELECT * FROM cat') as $row) { if ($row[1] === 'TABLE' || $row[1] === 'VIEW') { $tables[] = ['name' => $row[0], 'view' => $row[1] === 'VIEW']; } } return $tables; }