Post reply

If exist in Constraint Drop

  • February 25, 2009 at 1:45 pm

    #200699

    I have the following procedure that's suppose to drop a constraint. How do I add the If exist clause:

    EXECUTE IMMEDIATE 'ALTER TABLE MCCOYS.CUSTOMER_RICH_CONTACTS DROP' ||

    'CONSTRAINT CUSTOMER_RICH_CONTACTS_RO1';

  • February 26, 2009 at 1:30 am

    #950453

    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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply