DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Foreign key with cascade

  1. #1
    Join Date
    Nov 2000
    Posts
    205
    If we did not create the foreign key with the cascade option but want to add it now, how do we do it?

    Have been searching and cannot find the syntax... Looks like there is no modify constraint (besides changing its status)

    Thanks,
    Nirasha

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    well if I remmeber right you cannot add attributes to a constraint, most probably you have to drop and recreate the constraint

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width