select
'ALTER TABLE '+o.name+' NOCHECK CONSTRAINT '+fk.name+';' AS Command
from
sys.foreign_keys fk
JOIN sys.all_objects o ON (fk.parent_object_id=o.object_id)
posted on 2014-03-10 19:37 中子持心 阅读(169) 评论(0) 编辑 收藏 举报