Updatable views

Dear database experts,

Can somebody enumerate the problems with an updatable view for me ? With an updatebleview:= joined set of related tables and relations from which rows can be updated, inserted and deleted like you can in a simple table or master-detail relation.

My first try is to find hierarchy in de database by finding the absolute parents assigning them level 0. Parents of my table are considered those relations in which my foreign key doesnt allow DBNull.
Then from there on proceed to give every table that has no parents but level 0 parents a level 1 etc.

Problems seem to be autojoins and multiple relations between tables. Those problem can be solved to use every table only once in the scan.

So the first question is: will this way of hierarchising the relational db always valid ?

Then secondly given the hierarchy what problems remain when we talk about insert/update/delete and all kinds of combinations of those ?

Regards and tx for answering,

Rick Elbers Received on Mon Dec 05 2005 - 14:25:32 CST