ON DELETE CASCADE
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: ON DELETE CASCADE

  1. #1
    Join Date
    Dec 2000
    Posts
    1

    Unhappy

    Hi ,
    I have created tables in a database . I created referential inegrity constraints for various tables spanning across schemas. How can I change all the constrinst to ON DELETE CASCADE ? Can someone help me with a script ?

    Thanks,
    Fathima

  2. #2
    Join Date
    May 2000
    Location
    Portsmouth, NH, USA
    Posts
    378

    Talking more info


    What exactly do you want to do?

    you want to delete data or drop a table?

    - magnus

  3. #3
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    do an alter table on the table on which you would like to set the ON DELETE CASCADE constraint on.

    ALTER TABLE table_name MODIFY CONSTRAINT ....

    Hope this would help you.

    Sam

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