ray.gabriel (2/25/2009)
EXECUTE IMMEDIATE
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
Gail Shaw
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