IF EXISTS (SELECT 1 from sys.objects where name = 'CUSTOMER_RICH_CONTACTS_RO1')
  ALTER TABLE MCCOYS.CUSTOMER_RICH_CONTACTS DROP CONSTRAINT CUSTOMER_RICH_CONTACTS_RO1

We walk in the dark places no others will enter
We stand on the bridge and no one may pass