reg deleting an entry from table

Ambili S · Active User Joined: 06 Sep 2007 Posts: 112 Location: India

I have 2 tables T1 and T2 , with the following fields and data.

T1 :
Eno : a1
Ename : Name1
Edept no : D1

T2 :
Dept no : D1
Dept name : Dept-one

My query is if i delete the D1 entry from T2 , what would happen to Edept no in T1 ?

Thanks

dick scherrer · Posted: Wed Sep 22, 2010 9:43 am

Hello,

If the 2 tables are unrelated, nothing would happen. . . One row would be deleted from the T2 table and the other table would remain unchanged.

I suspect there is more to your question, but you need to post table definitions for amore specific answer. . . Like is there a foreign key. . .

Ambili S · Active User Joined: 06 Sep 2007 Posts: 112 Location: India

what if there is a foreign key ?

nareshkp · New User Joined: 26 Sep 2007 Posts: 28 Location: Bangalore

Check this topic posted earlier in this forum.