That doesn't look like T-SQL.
If it is T-SQL, checks are done like this
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
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)SQL In The Wild
: Discussions on DB performance with occasional diversions into recoverability
We walk in the dark places no others will enter
We stand on the bridge and no one may pass