Foreign keys

[mahua]

Need a query to find out all tables in a database that uses foreign keys & constraints , drop them & then recreate them in the same way so as not to affect the database.

Please mail at mahua_saha@hotmail.com

 

[kudlaguy]

Hi
You can form a query


select distinct a.name from sysobjects a, sysobjects b
where a.id = b.parent_obj and b.type in ('F','C')

and then use SQL DMO to generate the scripts to recreate these objects.

Hope this helps..

Rgds
Kudlaguy