rem
rem Will drop all constraints for the executing owned by the executing
rem user
rem
rem Note: This script will not remove indexes 
rem
rem  Created by Ed Campbell on 7/31/02
rem
rem 
set linesize 132
set pagesize 0
set heading off
set verify off
set echo off
set feedback off
set termout off
spool drop_constxxx.sql
prompt drop_constxxx.lis

SELECT 'ALTER TABLE '|| table_name ||' DROP CONSTRAINT '|| constraint_name ||';'
  FROM user_constraints
  WHERE owner = 'DESIGN2';

prompt spool off
spool off
@drop_constxxx.sql
prompt Check drop_constraint.lis log file for any errors