On Wed, 31 Jan 2001, Raymond Chui wrote:
> I have three tables:
>
> CREATE TABLE table1 (
> idchar(8) NOT NULL,
>
> PRIMARY KEY (id)
> );
>
> CREATE TABLE table2 (
> idchar(8) NOT NULL,
>
> PRIMARY KEY (id),
> FOREIGN KEY (id) REFERENCES table1 (id) ON DELETE CASCADE
> );
>
I have three tables:
CREATE TABLE table1 (
idchar(8) NOT NULL,
PRIMARY KEY (id)
);
CREATE TABLE table2 (
idchar(8) NOT NULL,
PRIMARY KEY (id),
FOREIGN KEY (id) REFERENCES table1 (id) ON DELETE CASCADE
);
CREATE TABLE table3 (
idchar(8) NOT NULL,
codechar(2) NOT NULL,
o
