1,查询数据库中的外键约束 select name from sys.foreign_key_columns f join sys.objects o on f.constraint_object_id=o.object_id 2,根据名称删除约束 alter table [tblName] drop constraint [约束名]