USE T202627 SELECT * FROM COMPANY_DETAIL 25TH001 --DELETE FROM COMPANY_DETAIL WHERE CompCode='25TH001' DELETE FROM OPENING_PURCHASE_DETAIL DELETE FROM OPENING_PURCHASE_ADDLESS_DETAIL DELETE FROM OPENING_PURCHASE_IMAGES_DETAIL DELETE FROM OPENING_PURCHASE_ITEM_DETAIL DELETE FROM OPENING_PURCHASE_TRANSPORT_DETAIL