Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Posts
    33

    Arrow Unanswered: ON DELETE RESTRICT vs ON DELETE NO ACTION

    Hi folks,

    so what's the diffenence between ON DELETE RESTRICT and ON DELETE NO ACTION ?

    Thanks
    ME

  2. #2
    Join Date
    Nov 2004
    Posts
    374

    foreign keys

    as to the documentation none : just for comptaibility reason.....
    If RESTRICT or NO ACTION is specified, an error occurs and no rows are deleted.
    Best Regards, Guy Przytula
    Best Regards, Guy Przytula
    DB2/ORA/SQL Services
    DB2 DBA & Advanced DBA Certified
    DB2 Dprop Certified
    http://users.skynet.be/przytula/dbss.html

  3. #3
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Actually there is a difference and it is in the documentation. I answerd this question earlier:

    http://www.dbforums.com/t1051558.html

    Andy

Posting Permissions

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