Re: Retrieving affected tables

Hannes Dorbath wrote:
> On 06.02.2007 14:19, Richard Huxton wrote:
>>> What is best way to retrieve all affected tables of an select
>>> statement? (Besides parsing the raw SQL).
>>
>>  From where? As a client-application function? As a user-callable
>> function in the server? From within the parse/execute code?
>
>  From a client application.

Parsing the sql is the only way I can think of.

You could feed it through EXPLAIN I suppose, but there's no way to dump
the query-plan as a data-structure to the client. You can log a verbose
query-plan, but that's not going to help you.

--
   Richard Huxton
   Archonet Ltd