Determine underlying tables in a view

From: Sporge <RonGeorge_at_hotmail.com>
Date: 10 May 2004 00:46:15 -0700
Message-ID: <7e3b24c7.0405092346.799fa0e0_at_posting.google.com>

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 - 09:46:15 CEST

This message: [ Message body ]
Next message: Galina: "Re: Do I need to create a field type LONG?"
Previous message: Michael: "Importing Data to DB with Added tables / columns"
Next in thread: Minesh: "Re: Determine underlying tables in a view"
Reply: Minesh: "Re: Determine underlying tables in a view"
Maybe reply: Sporge: "Re: Determine underlying tables in a view"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message