Add new DROP procedure.  Make drop behavior clear when tables exist but the view is disabled