Advanced Search

Return to Snippet

Revision: 30651
at August 18, 2010 23:16 by kamilch
Initial Code 
select
    'ALTER TABLE '||TABLE_NAME||' DISABLE CONSTRAINTS '||CONSTRAINT_NAME||';'
from
    user_constraints
where
    r_constraint_name =
    (select constraint_name from user_constraints where
        lower(table_name) = 'parent_table' and constraint_type = 'P')
    and constraint_type = 'R'
;
Initial URL 









Initial Description














Initial Title





Disable constraints for child tables









Initial Tags














Initial Language





SQL