-- This script will create a SQL script to drop all triggers in the current schema.
-- Mark Reineck 1-8-1998

set feedback off
set head off
set echo off
set recsep off
set pages 50000
set long 5000
set lines 200

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

spool deltrigr.sql

-- Write the SQL stastements to rebuild the triggers

select 'drop trigger ' || trigger_name || ';' from user_triggers;

spool off;

-- Reset some stuff

set feedback on
set head on
set echo on