修改字段时,如果有约束,就会提示无法进行操作,这时不妨在sql 后面加上nocheck CONSTRAINT all,执行命令后再恢复check constraint all,例如:
ALTER TABLE TblDetail nocheck CONSTRAINT allDROP COLUMN tempDes CASCADEALTER TABLE CLine_LineRouteDayDetail check constraint all