DROP VIEW COUNT_PRODUCT_ORDERS;

ALTER TABLE ORDERS DROP CONSTRAINT FK_ORDER_CUSTOMER;
ALTER TABLE ORDER_ITEM DROP CONSTRAINT FK_ORDER_ITEM_ORDER; 
ALTER TABLE ORDER_ITEM DROP CONSTRAINT FK_ORDER_ITEM_PRODUCT; 
ALTER TABLE PRODUCT DROP CONSTRAINT FK_PRODUCT_SUPPLIER; 

DROP TABLE CUSTOMER;
DROP TABLE ORDERS;
DROP TABLE ORDER_ITEM;
DROP TABLE PRODUCT;
DROP TABLE SUPPLIER;