alter table ts_userinfo
drop constraint FK_TS_USERI_REFERENCE_TS_GOVER
go
if exists (select 1
from sysobjects
where id = object_id('ts_bulletin')
and type = 'U')
drop table ts_bulletin；
alter table ts_government
add constraint FK_TS_GOVER_REFERENCE_TS_UNITG foreign key (ug_id)
references ts_unitgroup (ug_id)
on delete cascade;
if exists (select 1
from sysobjects
where id = object_id('Trigger_1')
and type = 'TR')
drop trigger Trigger_1
go
create trigger trig_del on ts_government
for delete
as
begin transaction
delete from ts_userinfo where ui_id in(
select ui_id from ts_underunit where g_id in(
select g_id from deleted))
delete from ts_underunit where g_id in(select g_id from deleted)
commit transaction
Trackback: http://tb.donews.net/TrackBack.aspx?PostId=139176