Question

如何使用一条sql语句删除多张表中的数据？

如下sql语句所有的表都有一个对应的dbid，怎么实现通过一条语句删除所有表中的数据，不用一条一条的delete语句执行，请大神帮忙看看！！
delete from cfg_skill_level where person_dbid = 195
delete from cfg_login_info where person_dbid = 195
delete from cfg_app_rank where person_dbid = 195
delete from cfg_password_history where person_dbid = 195
delete from cfg_flex_prop where object_type = 3 and object_dbid = 195
delete from cfg_ace where user_type = 3 and user_dbid = 195
delete from cfg_ace where object_type = 3 and object_dbid = 195
delete from cfg_person where dbid = 195
delete from cfg_agent_group where group_dbid = 108 and agent_dbid = 195
delete from cfg_agent_group where group_dbid = 104 and agent_dbid = 195
delete from cfg_obj_folder where folder_dbid = 105 and folder_type = 22 and object_dbid = 195 and object_type = 3
以各表where条件删除各表中的数据

Answer 1

在源表中使用触发器，把这些相应表都一并删除。
或是设置主外键，使之级联删除。

Answer 2

delete
t三
where
t三.B列
in
(
select
B列
from
t二
inner
join
t一
on
t二.A列=t一.A列
);
delete
t二
where
t二.A列
in
(
select
A列
from
t一
)
说明两sql语句间加号执行点击sql
server
菜单新建查询弹新窗口运行述语句普通sql语句删除两表做与sql
server
内机制