filter used tables out of complex script
From: Jeroen Houben <huuub_at_skynet.be>
Date: 4 Mar 2004 07:31:16 -0800
Message-ID: <1ba301aa.0403040731.45bfee03_at_posting.google.com>
situation:
[Quoted] On unix we have a lot of reports (.sql scripts) that create temporary tables etc.
In the end it spools a report.
(bad system but historic.. etc...)
question:
Is there a script/tool(perl...) that is able to filter the used tables out of all the statements in the sql script? (Out of the statements like create table as select ... etc.)
It's pretty complex I guess. But it can be done.
Date: 4 Mar 2004 07:31:16 -0800
Message-ID: <1ba301aa.0403040731.45bfee03_at_posting.google.com>
situation:
[Quoted] On unix we have a lot of reports (.sql scripts) that create temporary tables etc.
In the end it spools a report.
(bad system but historic.. etc...)
question:
Is there a script/tool(perl...) that is able to filter the used tables out of all the statements in the sql script? (Out of the statements like create table as select ... etc.)
It's pretty complex I guess. But it can be done.
It's to automattically extract the used tables out of sql files to be
short...
(sorry for English :s)
Received on Thu Mar 04 2004 - 16:31:16 CET