數(shù)據(jù)庫(kù)系統(tǒng)概論實(shí)驗(yàn)設(shè)計(jì)答案-文庫(kù)吧
2025-06-07 15:05 本頁(yè)面
【正文】 if exists(select 1 from where role=39。FK_ASSOCIAT_ASSOCIATI_商店管理員39。) then alter table Association_4 delete foreign key FK_ASSOCIAT_ASSOCIATI_商店管理員end if。if exists(select 1 from where role=39。FK_ASSOCIAT_ASSOCIATI_逾期罰款通知39。) then alter table Association_4 delete foreign key FK_ASSOCIAT_ASSOCIATI_逾期罰款通知end if。if exists(select 1 from where role=39。FK_同意租借_同意租借_商店管理員39。) then alter table 同意租借 delete foreign key FK_同意租借_同意租借_商店管理員end if。if exists(select 1 from where role=39。FK_同意租借_同意租借2_租借流水帳39。) then alter table 同意租借 delete foreign key FK_同意租借_同意租借2_租借流水帳end if。if exists(select 1 from where role=39。FK_沒(méi)有庫(kù)存_沒(méi)有庫(kù)存_商店管理員39。) then alter table 沒(méi)有庫(kù)存 delete foreign key FK_沒(méi)有庫(kù)存_沒(méi)有庫(kù)存_商店管理員end if。if exists(select 1 from where role=39。FK_沒(méi)有庫(kù)存_沒(méi)有庫(kù)存2_預(yù)約登記39。) then alter table 沒(méi)有庫(kù)存 delete foreign key FK_沒(méi)有庫(kù)存_沒(méi)有庫(kù)存2_預(yù)約登記end if。if exists(select 1 from where role=39。FK_登記_登記_商店管理員39。) then alter table 登記 delete foreign key FK_登記_登記_商店管理員end if。if exists(select 1 from where role=39。FK_登記_登記2_歸還登記39。) then alter table 登記 delete foreign key FK_登記_登記2_歸還登記end if。if exists(select 1 from where role=39。FK_租借_租借_客戶39。) then alter table 租借 delete foreign key FK_租借_租借_客戶end if。if exists(select 1 from where role=39。FK_租借_租借2_商店管理員39。) then alter table 租借 delete foreign key FK_租借_租借2_商店管理員end if。if exists( select 1 from i, t where = and =39。Association_5_FK39。 and =39。Association_439。) then drop index end if。if exists( select 1 from i, t where = and =39。Association_4_FK39。 and =39。Association_439。) then drop index end if。if exists( select 1 from i, t where = and =39。Association_4_PK39。 and =39。Association_439。) then drop index end if。if exists( select 1 from where table_name=39。Association_439。 and table_type in (39。BASE39。, 39。GBL TEMP39。)) then drop table Association_4end if。if exists( select 1 from i, t where = and =39。同意租借2_FK39。 and =39。同意租借39。) then drop index end if。if exists( select 1 from i, t where = and =39。同意租借_FK39。 and =39。同意租借39。) then drop index end if。if exists( select 1 from i, t where = and =39。同意租借_PK39。 and =39。同意租借39。) then drop index end if。if exists( select 1 from where table_name=39。同意租借39。 and table_type in (39。BASE39。, 39。GBL TEMP39。)) then drop table 同意租借end if。if exists( select 1 from i, t where = and =39。商店管理員_PK39。 and =39。商店管理員39。) then drop index end if。if exists( select 1 from where table_name=39。商店管理員39。 and table_type in (39。BASE39。, 39。GBL TEMP39。)) then drop table 商店管理員end if。if exists( select 1 from i, t where = and =39。客戶_PK39。 and =39?？蛻?9。) then drop index end if。if exists( select 1 from where table_name=39?？蛻?9。 and table_type in (39。BASE39。, 39。GBL TEMP39。)) then drop table 客戶end if。if exists( select 1 from i, t where = and =39。歸還登記_PK39。 and =39。歸還登記39。) then drop index end if。if exists( select 1 from where table_name=39。歸還登記39。 and table_type in (39。BASE39。, 39。GBL TEMP39。)) then drop table 歸還登記end if。if exists( select 1 from i, t where = and =39。沒(méi)有庫(kù)存2_FK39。 and =39。沒(méi)有庫(kù)存39。) then drop index end if。if exists( select 1 from i, t where = and =39。沒(méi)有庫(kù)存_FK39。 and =39。沒(méi)有庫(kù)存39。) then drop index end if。if exists( select 1 from i, t where = and =39。沒(méi)有庫(kù)存_PK39。 and =39。沒(méi)有庫(kù)存39。) then drop index end if。if exists( select 1 from where table_name=39。沒(méi)有庫(kù)存39。 and table_type in (39。BASE39。, 39。GBL TEMP39。)) then drop table 沒(méi)有庫(kù)存end if。if exists( select 1 from i, t where = and =39。登記2_FK39。 and =39。登記39。) then drop index end if。if exists( select 1 from i, t where = and =39。登記_FK39。 and =39。登記39。) then drop index end if。if exists( select 1 from i, t where = and =39。登記_PK39。 and =39。登記39。) then drop index end if。if exists( select 1 from where table_name=39。登記39。 and table_type in (39。BASE39。, 39。GBL TEMP39。)) then drop table 登記end if。if exists( select 1 from i, t where = and =39。租借2_FK39。 and =39。租借39。) then drop index end if。if exists( select 1 from i, t where = and =39。租
環(huán)評(píng)公示相關(guān)推薦
鄂ICP備17016276號(hào)-1