摘要： 1)禁止所有表约束的SQLselect'altertable'+name+'nocheckconstraintall'fromsysobjectswheretype='U'2)删除所有表数据的SQLselect'TRUNCATETABLE'+namefromsysobjectswheretype='U'3)恢复所有表约束的SQLselect'altertable'+name+'checkconstraintall'fromsysobjectswheretype='U' 阅读全文