set echo off
--
--  dropfk1.sql
--
--  Constraints - Drop all the foreign keys part of a specific table for the current user/schema login
--
--  Usage: @dropfk1 table_name
--
set termout off
set verify off
set doc off
set feedback off
set recsep off
set pagesize 0
--
define lsize=133
set linesize &&lsize
--
define out_file=dropfk1.ddl
spool &&out_file
--
SELECT 'alter table '||fk.owner||'.'||fk.table_name||' drop constraint '||fk.constraint_name||';'
from  user_constraints fk
WHERE fk.table_name  = upper('&&1') and constraint_type = 'R'
ORDER BY  fk.constraint_name ;
--
spool off
set doc off
set feedback on
set pagesize 30
set termout on
set echo on
start &&out_file
-- exit