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