ALTER TABLE Document DROP CONSTRAINT FK_Document_Document_Type

ALTER TABLE Document DROP CONSTRAINT FK_Document_Inventory_Count

ALTER TABLE Document DROP CONSTRAINT FK_Document_Purchase

ALTER TABLE Document_Type DROP CONSTRAINT FK_Document_Type_Document_Category

ALTER TABLE Inventory_Count_Item DROP CONSTRAINT FK_Inventory_Count_Item_Inventory_Count

ALTER TABLE Inventory_Count_Item DROP CONSTRAINT FK_Inventory_Count_Item_Item

ALTER TABLE Item DROP CONSTRAINT FK_Item_Supplier

ALTER TABLE Purchase_Item DROP CONSTRAINT FK_Purchase_Item_Item

ALTER TABLE Purchase_Item DROP CONSTRAINT FK_Purchase_Item_Purchase

ALTER TABLE Purchase DROP CONSTRAINT FK_Purchase_Supplier

ALTER TABLE Stock_History DROP CONSTRAINT FK_Stock_History_Document

ALTER TABLE Stock_History DROP CONSTRAINT FK_Stock_History_Item

DROP TABLE IF EXISTS Document CASCADE

DROP TABLE IF EXISTS Document_Category CASCADE

DROP TABLE IF EXISTS Document_Type CASCADE

DROP TABLE IF EXISTS Inventory_Count CASCADE

DROP TABLE IF EXISTS Inventory_Count_Item CASCADE

DROP TABLE IF EXISTS Item CASCADE

DROP TABLE IF EXISTS Purchase CASCADE

DROP TABLE IF EXISTS Purchase_Item CASCADE

DROP TABLE IF EXISTS Stock_History CASCADE

DROP TABLE IF EXISTS Supplier CASCADE