Determine underlying tables in a view

[Sporge]

Hi All

Is there any way to determine what the underlying tables are in a view
from within a stored procedure?

I've written a function that parses the View text but I was hoping for
something more elegant.

Any help in this regard would be appreciated.
Ron

[Minesh]

Hi Ron,

You can use the following query to find out whicc tables your view is
dependent on

select name , type , referenced_name , referenced_type
from user_dependencies where name = 'VIEW_NAME' and type = 'VIEW' and
referenced_type = 'TABLE'

I hope this helps

Thanks

Minesh

Ro*******@hotmail.com (Sporge) wrote in message news:<7e**************************@posting.google. com>...

Hi All

Is there any way to determine what the underlying tables are in a view
from within a stored procedure?

I've written a function that parses the View text but I was hoping for
something more elegant.

Any help in this regard would be appreciated.
Ron

[Sporge]

Hi Minesh

Thanks for the help.

Regards,
Ron