Informix

 View Only
Expand all | Collapse all

Support for ON DELETE SET NULL and ON UPDATE CASCADE clauses in FOREIGN KEY statements

  • 1.  Support for ON DELETE SET NULL and ON UPDATE CASCADE clauses in FOREIGN KEY statements

    Posted Mon March 25, 2024 03:59 PM
    Edited by Doug Lawry Mon March 25, 2024 04:00 PM

    New RFE:

    https://ideas.ibm.com/ideas/INFX-I-603

    Please vote!

    ------------------------------
    Doug Lawry
    Oninit Consulting
    ------------------------------



  • 2.  RE: Support for ON DELETE SET NULL and ON UPDATE CASCADE clauses in FOREIGN KEY statements

    IBM Champion
    Posted Mon March 25, 2024 04:14 PM

    Not a fan of cascading foreign keys (I have never implemented an ON DELETE CASCADE anywhere) and I definitely would never include ON DELETE SET NULL in any schema I produced, but I did vote for the RFE.



    ------------------------------
    Art S. Kagel, President and Principal Consultant
    ASK Database Management Corp.
    www.askdbmgt.com
    ------------------------------

    Original Message


  • 3.  RE: Support for ON DELETE SET NULL and ON UPDATE CASCADE clauses in FOREIGN KEY statements

    Posted Mon March 25, 2024 04:35 PM
    Edited by Doug Lawry Mon March 25, 2024 04:35 PM

    Thanks, Art!