--如果你是7.0,就写触发器来实现--同步删除的触发器:
create tr_delete on 主表
for delete
as
delete 从表1
from 从表1 a join deleted b on a.外键字段=b.主键字段--如果还在其他从表,则继续写删除语句
go
create tr_delete on 主表
for delete
as
delete 从表1
from 从表1 a join deleted b on a.外键字段=b.主键字段--如果还在其他从表,则继续写删除语句
go
create trigger tr_update on 主键
for update
as
select id=identity(int,1,1),主键 into #i from inserted
select id=identity(int,1,1),主键 into #d from deletedupdate 从表1 set 外键字段=i_主键
from 从表1 a join(
select i_主键=i.主键,d_主键=d.主键
from #i i join #d d on i.id=d.id
)b on a.外键字段=d_主键--如果还在其他从表,更新语句和更新从表1的一样