从后往前删即可。
delete answer (或 truncate table answer )
delete Question (或 truncate table Question )
delete teachingUnit (或 truncate table teachingUnit )
delete Course (或 truncate table Course )
delete answer (或 truncate table answer )
delete Question (或 truncate table Question )
delete teachingUnit (或 truncate table teachingUnit )
delete Course (或 truncate table Course )
create proc test
as
truncate table answer
truncate table Question
truncate table teachingUnit
truncate table Course
go调用: exec test
as
delete from table answer
delete from table Question
delete from table teachingUnit
delete from table Course go--run
execute test
create proc test
as
delete from answer
delete from Question
delete from teachingUnit
delete from Course goexecute test
先生成SQL脚本,删除表
运行脚本.也行.