protected function dropViews()
    {
        $views = $this->db->query(
            'SHOW FULL TABLES WHERE TABLE_TYPE LIKE "VIEW"',
            DbAdapter::QUERY_MODE_EXECUTE
        );

        foreach ($views as $view) {
            $this->db->query(
                'DROP VIEW '.reset($view),
                DbAdapter::QUERY_MODE_EXECUTE
            );
        }
    }
protected function dropViews()
    {
        $views = $this->db->query(
            'SHOW FULL TABLES WHERE TABLE_TYPE LIKE "VIEW"',
            DbAdapter::QUERY_MODE_EXECUTE
        );

        foreach ($views as $view) {
            $this->db->query(
                'DROP VIEW '.reset($view),
                DbAdapter::QUERY_MODE_EXECUTE
            );
        }
    }
protected function dropViews ( ) { $ views = $ this -> db -> query ( 'SHOW FULL TABLES WHERE TABLE_TYPE LIKE "VIEW"' , DbAdapter :: QUERY_MODE_EXECUTE ) ; foreach ( $ views as $ view ) { $ this -> db -> query ( 'DROP VIEW ' . reset ( $ view ) , DbAdapter :: QUERY_MODE_EXECUTE ) ; } }
Drop all views from the database
Drop all views from the database