Re: Determine underlying tables in a view

From: Minesh <jminesh_at_hotmail.com>
Date: 10 May 2004 09:19:55 -0700
Message-ID: <2fee53a9.0405100819.3febc7dd@posting.google.com>

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

RonGeorge_at_hotmail.com (Sporge) wrote in message news:<7e3b24c7.0405092346.799fa0e0_at_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
Received on Mon May 10 2004 - 11:19:55 CDT