Reputation: 12389
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
Upvotes: 4
Views: 24531
Reputation: 3037
SELECT NAME
from user_dependencies
where referenced_name = 'PRICE'
Upvotes: 8