Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2006
    Posts
    6

    Unanswered: on delete restrict

    hi guys
    presently for all my foreign keys have relation on delete cascade
    and i want to change it to on delete restrict
    iam working on linux platform

  2. #2
    Join Date
    Nov 2004
    Posts
    374

    foreign key

    create a script gathering the drop foreign key statement from catalogs and a create foreign key with restrict .....; this can be done with sql statements that output fixed text....
    Best Regards, Guy Przytula
    DB2/ORA/SQL Services
    DB2 DBA & Advanced DBA Certified
    DB2 Dprop Certified
    http://users.skynet.be/przytula/dbss.html

Posting Permissions

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