?? delete.sql
字號(hào):
// Delete the tutorial database tablesALTER 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;
?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -