dropschemahsql.sql

来自「基于struts框架的web开发应用实例」· SQL 代码 · 共 52 行

-- DROP INDEX XAK1STOREFRONT_PRODUCT;

DROP TABLE STOREFRONT_PRODUCT IF EXISTS;

ALTER TABLE STOREFRONT_ALBUM DROP CONSTRAINT R_270A;

ALTER TABLE STOREFRONT_ALBUM DROP CONSTRAINT R_265A;

-- DROP INDEX XIF270STOREFRONT_ALBUM;

-- DROP INDEX XIF265STOREFRONT_ALBUM;

-- DROP INDEX XIE1STOREFRONT_ALBUM;

DROP TABLE STOREFRONT_ALBUM IF EXISTS;

DROP TABLE STOREFRONT_GENRE IF EXISTS;

-- DROP INDEX XIE1STOREFRONT_ARTIST;

DROP TABLE STOREFRONT_ARTIST IF EXISTS;

-- DROP INDEX XAK1STOREFRONT_USER;

DROP TABLE STOREFRONT_USER IF EXISTS;

DROP TABLE STOREFRONT_SEQUENCE_GENERATOR IF EXISTS;

DROP TABLE STOREFRONT_PROFILE IF EXISTS;

-- DROP INDEX XIF460STOREFRONT_ORDER_ITEM;

-- DROP INDEX XIF40STOREFRONT_ORDER_ITEM;

DROP TABLE STOREFRONT_ORDER_ITEM IF EXISTS;

DROP TABLE STOREFRONT_ORDER IF EXISTS;

-- DROP INDEX XIF463STOREFRONT_ADDRESS_BOOK;

-- ALTER TABLE STOREFRONT_ADDRESS_BOOK DROP CONSTRAINT TRUE_FALSE161A;

DROP TABLE STOREFRONT_ADDRESS_BOOK IF EXISTS;