delete.sql

来自「java 的关于web serive教程」· SQL 代码 · 共 44 行

// Delete the tutorial database tables

ALTER TABLE EJB_ORDER_PART DROP CONSTRAINT FK_1;
ALTER TABLE EJB_ORDER_VENDOR_PART DROP CONSTRAINT FK_2;
ALTER TABLE EJB_ORDER_VENDOR_PART DROP CONSTRAINT FK_3;
ALTER TABLE EJB_ORDER_LINEITEM DROP CONSTRAINT FK_4;
ALTER TABLE EJB_ORDER_LINEITEM DROP CONSTRAINT FK_5;

ALTER TABLE EJB_ROSTER_TEAM DROP CONSTRAINT fk_league_id;
ALTER TABLE EJB_ROSTER_TEAM_PLAYER DROP CONSTRAINT fk_player_id;
ALTER TABLE EJB_ROSTER_TEAM_PLAYER DROP CONSTRAINT fk_team_id;
ALTER TABLE EJB_ROSTER_LEAGUE DROP CONSTRAINT pk_league;
ALTER TABLE EJB_ROSTER_PLAYER DROP CONSTRAINT pk_player;
ALTER TABLE EJB_ROSTER_TEAM DROP CONSTRAINT pk_team;

ALTER TABLE BANK_TX DROP CONSTRAINT fk_tx_account_id;
ALTER TABLE BANK_CUSTOMER_ACCOUNT_XREF DROP CONSTRAINT fk_bank_customer_id;
ALTER TABLE BANK_CUSTOMER_ACCOUNT_XREF DROP CONSTRAINT fk_bank_account_id;
ALTER TABLE BANK_ACCOUNT DROP CONSTRAINT pk_account;
ALTER TABLE BANK_CUSTOMER DROP CONSTRAINT pk_customer;
ALTER TABLE BANK_TX DROP CONSTRAINT pk_tx;
ALTER TABLE BANK_NEXT_ID DROP CONSTRAINT pk_next_id;

DROP TABLE WEB_BOOKSTORE_BOOKS;

DROP TABLE EJB_ROSTER_LEAGUE;
DROP TABLE EJB_ROSTER_PLAYER;
DROP TABLE EJB_ROSTER_TEAM;
DROP TABLE EJB_ROSTER_TEAM_PLAYER;

DROP TABLE EJB_ORDER_LINEITEM;
DROP TABLE EJB_ORDER_ORDER;
DROP TABLE EJB_ORDER_VENDOR_PART;
DROP TABLE EJB_ORDER_VENDOR;
// DROP TABLE EJB_ORDER_PART_DETAIL;
DROP TABLE EJB_ORDER_PART;
DROP TABLE EJB_ORDER_SEQUENCE_GENERATOR;

DROP TABLE BANK_CUSTOMER_ACCOUNT_XREF;
DROP TABLE BANK_TX;
DROP TABLE BANK_CUSTOMER;
DROP TABLE BANK_ACCOUNT;
DROP TABLE BANK_NEXT_ID;