Subject Getting underlying table
Author Elmar Haneke
Hi,

How can I get the name of the physical table accessed by an Query
which is running against an view. I'm using the API.

Example

Create Table SampleTable ( ... )

Create View SampleView as Select .. FROM Table ...

I'm running "SELECT * from Sample View"

By looking at "alias_name" I can detect the Views Name "SampleView"
from the prepared statement. But, I want to know that the data comes
from "SampleTable".

Elmar