db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Vasja Pupkin <tr...@gonivo.org.ua>
Subject ON UPDATE CASCADE in derby
Date Thu, 24 Nov 2005 12:42:31 GMT
Is there any chance to implement such statement in derby?

CREATE TABLE A (
    ax INTEGER NOT NULL,

    PRIMARY KEY(ax)
);

CREATE TABLE B (
    
    bx INTEGER NOT NULL,
    
    FOREIGN KEY (bx)     REFERENCES A (ax)
    ON UPDATE CASCADE -- can't make this work
    ON DELETE CASCADE
);


P.S. I found this working in HSQL, M$SQL, PostgreSQL... but not in
debry :(


Mime
View raw message