Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to track which tables/views/etc depends from a table, in Oracle

How to know which objects (tables/views/etc) uses a certain table?

I have to replace my table PRICE. So, is there something like?

select system.dependencies from PRICE
like image 987
Topera Avatar asked Feb 26 '23 05:02

Topera


1 Answers

SELECT NAME
from user_dependencies
where referenced_name = 'PRICE'
like image 182
Adam Butler Avatar answered Mar 01 '23 01:03

Adam Butler