You are right. Dropping the views and tables and creating them anew does not give a problem. Probably the error I first got was a different one. Well problem solved. In my case it does not matter, but dropping and recreating I find a much better option as deleting and recreating the database.