Great idea - but I found a flaw...

If you have a view (2nd level) that references another view (1st level), unfortunately, the stored procedure does not drop any 2nd level...