adds drop views

as an update using create or replace is not possible.