ALTER TABLE plannedconsignments_tpdetails
DROP CONSTRAINT fk_clearing_agent;

ALTER TABLE plannedconsignments_tpdetails
DROP COLUMN clearing_agent_id;