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
|