-- This script will create a SQL script to drop any views in the current schema.
-- Mark Reineck 12-19-1997

set feedback off
set head off
set echo off

-- Write the script to a file, otherwise it is useless

spool mkviews.sql

select 'drop view ' || view_name || ';' from user_views; spool off;

-- Reset some stuff

set feedback on
set head on
set echo on