derby.drop.sql

来自「一个java写的加密算法」· SQL 代码 · 共 21 行

ALTER TABLE "DERBYPUBLIC"."CUSTOMERBEAN" DROP CONSTRAINT "PK_CUSTBEAN";
ALTER TABLE "DERBYPUBLIC"."SUBSCRIPTIONBEAN" DROP CONSTRAINT "PK_SUBSCRIPBEAN";
ALTER TABLE "DERBYPUBLIC"."ADDRESSBEAN" DROP CONSTRAINT "PK_ADDREAN";
ALTER TABLE "DERBYPUBLIC"."CUSTOMERBEANSUBSCRIPTIONBEAN" DROP CONSTRAINT "FK_CUSTOMERS"; 
ALTER TABLE "DERBYPUBLIC"."CUSTOMERBEANSUBSCRIPTIONBEAN" DROP CONSTRAINT "FK_SUBSCRIPTIONS";
ALTER TABLE "DERBYPUBLIC"."ADDRESSBEAN" DROP CONSTRAINT "FK_THIS";

ALTER TABLE "DERBYPUBLIC"."CUSTOMERBEAN" DROP CONSTRAINT "PK_CUSTOMERBEA";
ALTER TABLE "DERBYPUBLIC"."SUBSCRIPTIONBEAN" DROP CONSTRAINT "PK_SUBSCRIPTIO";
ALTER TABLE "DERBYPUBLIC"."SUBSCRIPTIONBEANCUSTOMERBEAN" DROP CONSTRAINT "FK_SUBSCRIPTIO";
ALTER TABLE "DERBYPUBLIC"."SUBSCRIPTIONBEANCUSTOMERBEAN" DROP CONSTRAINT "FK_CUSTOMERS";
DROP TABLE "DERBYPUBLIC"."SUBSCRIPTIONBEANCUSTOMERBEAN";
DROP TABLE "DERBYPUBLIC"."CUSTOMERBEAN";
DROP TABLE "DERBYPUBLIC"."SUBSCRIPTIONBEAN";
DROP TABLE "DERBYPUBLIC"."ADDRESSBEAN" ;

drop table CUSTOMERBEANSUBSCRIPTIONBEAN;
drop table ADDRESSBEAN;
drop table CUSTOMERBEAN;
drop table SUBSCRIPTIONBEAN;