在约束的末尾加上 on delete cascade
alter table V_PAPER
drop constraint FK_KS_PRO_P_REFERENCE;
alter table V_PAPER
add constraint FK_KS_PRO_P_REFERENCE foreign key (KS_POLICY_TID)
references V_POLICY (TID)
on delete cascade;
如果主表V_PAPER删除一条记录,那么V_ROLICY中对应的关联的数据也跟着删除。