Hi All,

How could I check complete dependency between table and view.
I have table emp has columns eno,ename,eaddrs
and view based on emp which is emp_v has columns e_no,e_name,e_addrs all these columns mapped with emp table.

My requirement is I want to find all column dependency of emp table with view emp_v column.

That which table column is mapped with views column.

(something like I will provide table name emp and view name emp_v and I will get

Table view
eno e_no

ename e_name

eaddrs e_addrs)

Is it possible with help of system tables.? or any other way...

Thanks in advance