Post reply

foreign key constraint options

  • July 17, 2008 at 4:46 am

    #77043

    Hi,

    I 'm trying to create a foreign key constraint using t-sql. Two of the options in the properties window for relationship is to . Is there any way I can set off these values with t-sql?

    Thanks,

    Angelos

  • July 17, 2008 at 5:52 am

    #844294

    Hi again,

    just in case you cannot see the question properly, I 'm reposting it :

    Is there a way I can programmatically turn off the options (a)enforce relationship for replication and (b)enforce relationship for inserts and updates. These are options in the property window when defining a foreign key relationship.

    Regards,

    Angelos

  • July 17, 2008 at 1:18 pm

    #844631

    WITH NOCHECK?

    NOT FOR REPLICATION?

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

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