开发者

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

开发者 https://www.devze.com 2023-01-16 09:40 出处:网络
How to know which objects (tables/views/etc) uses a certain table? I have to replace my table PRICE. So, is there something like?

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
开发者_Go百科


SELECT NAME
from user_dependencies
where referenced_name = 'PRICE'
0

精彩评论

暂无评论...
验证码 换一张
取 消