Cascade delete contraints - accessible through TSQL?

Hi all,

I was wondering if there is an easy way to loop through all contraints in a database and programmatically set the cascade delete to ON. I have a database with hundreds of contraints, so individually setting cascade delete on them is not optimal.

Thanks for any info in advance!

I think that the constraints are simply held in one of the system datatables, is there anyway to simply update that table?

You will have to drop and recreate the FK constraints to add the cascase option. Using DDLs is the only supported mechanism to achieve it.|||

Ok. is there a easy way to add and drop all contraints?