[Resolvido] Desabilitar Chave-Estrangeiras de tabelas.

Olá,

Segue script para desabilitar todas as chave-estrangeiras (FK) de um schema.

SET PAGESIZE 0SET FEEDBACK OFFSET VERIFY OFFSPOOL temp.sqlSELECT 'ALTER TABLE "' || a.table_name || '" DISABLE CONSTRAINT "' || a.constraint_name || '";'FROM all_constraints aWHERE a.constraint_type = 'R'AND	a.table_name = DECODE(Upper('&1'),'ALL',a.table_name,Upper('&1'))AND	a.owner = Upper('&2');SPOOL OFF-- Comment out following line to prevent immediate run@temp.sqlSET PAGESIZE 14SET FEEDBACK ONSET VERIFY ON

 Abraços, [http://forum.imasters.com.br/public/style_emoticons/](http://forum.imasters.com.br/public/style_emoticons/)default/clap.gif