Dropping all foreign keys

[Powernic]

Hi guys,

I need a way to drop all foreign keys of all tables on a given schema.

Does anyone know a way to do that, in an automated way?

Thanks a lot

Nicolas.

 

[Powernic]

I found a way to do it, if anyone is interested :

select 'alter table ', tbcreator, '.', tbname, ' DROP foreign key ', name from SYSIBM.SYSTABCONST where CONSTRAINTYP = 'F'

Regards

Nicolas

 

[kaushik1979]

Hi,
you can also do this

select 'alter table ',tabschema,'.',tabname, ' DROP Foreign key ', constname, ' ;' from syscat.tabconst where tabschema='URschema' and type='F' > script.dml

this will give you a file called script.dml which will have all the ALTER Table commands for all tables in ur schema with a foreign key. You can check the script before you run it so you can be sure thers nuthing wrong
Bye