Parsing a SQL Query

microsoft.public.sqlserver.programming

28 Jul 2005 3:18 PM

Pushkar

Hi,

In my application I have requirement to parse the SQL Select query and get the name of tables/views which were involved in that query.
Is there any free code available that does this task?
Or any library available that helps to parse the SQL select query.

Any help is appreciated.

Thanks
Pushkar

28 Jul 2005 3:51 PM

Jens SÃ¼ÃŸmeyer

SET SHOWPLAN_TEXT ON
GO
<SomeQuery>
GO
SET SHOWPLAN_TEXT OFF

--OR

SET STATISTICS IO ON
GO
<SomeQuery>
GO
SET STATISTICS IO OFF

HTH, Jens Suessmeyer.

Show quote

"Pushkar" wrote:

> Hi,
>
> In my application I have requirement to parse the SQL Select query and get the name of tables/views which were involved in that query.
> Is there any free code available that does this task?
> Or any library available that helps to parse the SQL select query.
>
> Any help is appreciated.
>
> Thanks
> Pushkar