获得外键约束名
select name
from sys.foreign_key_columns f join sys.objects o on f.constraint_object_id=o.object_idwhere f.parent_object_id=object_id('表名')
删除外键约束
alter table 表名 drop constraint 外键约束名
转自:http://www.cnblogs.com/weisenz/archive/2012/04/09/2439036.html