-
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]
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|