--TD 11343 Cannot delete a client if contact person has not been removed first 

ALTER TABLE CLIENTCONTACTPERSON
  DROP CONSTRAINT CLIENTCONTACTPERSON_CLIENT_ID;

ALTER TABLE CLIENTCONTACTPERSON
  ADD CONSTRAINT CLIENTCONTACTPERSON_CLIENT_ID FOREIGN KEY (CLIENT_ID)
  REFERENCES CLIENT (CLIENT_ID) ON DELETE CASCADE;