Post reply

Cascade Question

  • October 29, 2003 at 11:34 am

    #81446

    Is it possible to alter an existing FK constraint to allow cascades on update or delete? If so, what is the T-SQL syntax?

    I have been unable to get an Alter command to work, so the only way I know of to accomplish this is to drop the constraint and then recreate it.

  • October 29, 2003 at 1:24 pm

    #480175

    quote:

    Is it possible to alter an existing FK constraint to allow cascades on update or delete?

    No.

    quote:

    If so, what is the T-SQL syntax?

    I have been unable to get an Alter command to work, so the only way I know of to accomplish this is to drop the constraint and then recreate it.

    That's correct.

    --Jonathan



    --Jonathan

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

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