Get rid of all foreign key constraints on table

select 'alter table ' + t2.name + ' drop constraint ' + t3.name
from sysreferences a,
sysobjects t2,
sysobjects t3
where
a.fkeyid = t2.id
and
a.constid = t3.id
and t2.name like '%myttable%'


Here is one for the check-constraints:

select 'alter table ' + t2.name + ' drop constraint ' + t3.name
from sysconstraints a,
sysobjects t2,
sysobjects t3
where
a.id = t2.id
and
a.constid = t3.id
and t3.type ='C'
and t2.name like '%mytable%'


Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.