Dependent objects on a column
630050Jun 26 2012 — edited Jun 26 2012Is there a way to know the object names which is dependent on a column of a table?.
I am doing an impact analysis for a change in a column value of a table, fo this I am scanning all the objects which has a dependency on the table and looking out for code wherever the column has been used for any calculations. This is very time consuming.
Is there a table which stores all the ddl/sqls of table,views,mvs,functions,procedures,packages so that I can write a regular expresssion.
Thanks
Edited by: user627047 on Jun 26, 2012 12:13 AM