when use designer,
I have a question regarding foreign key.

I have a choice between "can the foreign key be updated?"

if i select no, what 's sql equivalent ?

let's say i have dept,emp table.

dept have deptno 10 and 20

emp tom belongs to dept 10.
i have no problem to change tom's deptno from 10 to 20.
seem that there are some kind of foreign forbide tom change
his deptno, what's that?

[Edited by bxr556 on 05-31-2001 at 12:36 PM]