-- Drop all the views in reverse order of create. -- drop view news_item_full_active; drop view news_item_unapproved; drop view news_item_revisions; drop view news_items_unapproved; drop view news_items_live_or_submitted; drop view news_items_approved;