retrieving the list of tables used in SELECT statement?

microsoft.public.dotnet.framework

12 Jul 2006 3:56 PM

Jéjé

Hi,

I want to list all the tables involved in a query.
Like the estimated plan in SQL server which identify the tables in a query
(or an SQL query editor identify the tables), I want the same thing in my
own code.
my user type a statement like:
select * from table1 inner join table2 on table1.id = table2.id where
toto=tata and date = ?

(OLEDB select type, with ? when there is a parameter)

so I want to list the tables only.

any sample is appreciate.

thanks.

Jerome.