一次操作不能同时删除两个表的数据
除非用触发器
create trigger tr_name on table1
for delete
as
delete table2 where id in (select id from deleted)
然后删除
delete table1 where id条件
触发器的操作命令主要有如下几种格式:
创建触发器:
Create Trigger 名称
On 表名
{FOR|AFTER|INSTEAD OF} { [INSERT] [,] [DELETE] [,] [UPDATE]}
As
Sql语句
修改触发器:
Alter Trigger 名称
删除触发器:
Drop Trigger 名称
..............