views:

25

answers:

1

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
+3  A: 
SELECT NAME
from user_dependencies
where referenced_name = 'PRICE'
Adam Butler
works perfect! tks a lot!
Topera