|< < 25 > >|

Foreign keys and updates

Example (same as before)

With slightly more data.

create table P( p_id int not null primary key, x int ); create table F( f_id int not null primary key, p_id int references P, y int );

P p_id x 1 123 2 456 3 789 4 111 F f_id p_id y 1001 1 999 1002 1 888 2001 2 777 3001 3 666 3002 3 555 3003 3 444

|< < 25 > >|