Unanswered: find dependency between table and view
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
Is it possible with help of system tables.? or any other way...