Subject | Getting underlying table |
---|---|
Author | Elmar Haneke |
Post date | 2004-02-06T13:56:40Z |
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
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