By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,851 Members | 1,752 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,851 IT Pros & Developers. It's quick & easy.

Determine underlying tables in a view

P: n/a
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
Jul 19 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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

Jul 19 '05 #2

P: n/a
Hi Minesh

Thanks for the help.

Regards,
Ron
Jul 19 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.