how delete works in view

Go down

how delete works in view

Post by subhajit on Sat Mar 27, 2010 5:17 pm

I have created a view using this:

create view v336916 as select e.eid, e.ename, d.did from employee7 e join dept7 d on (d.eid = e.eid);
now the tables are:
dept7
=====
DID DNAME EID
--- -------------------- ---
476 ggg
999 rrr 111
777 jjj
888 iii 333

employee7
=========
EID ENAME EADDR
--- -------------------- ------------------------------
456 jjj sss
667 Tay DTA
687 Ttt DTe
111 jjj sss
222 bbb jjj
333 ccc jjj
444 ppp ttt
765 ppp ttt



now when I am trying to delete a row from the view
delete from v336916 where eid=111;
but it is juat deleting it from the dept7 table not from employee7 table..please clear the doubts..

subhajit

Posts : 11
Points : 17
Join date : 2010-02-26

View user profile

Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum