Parse SQL to get involved tables/views?

Hi all,

I need to perform an analysis of a collection of SQL scripts to analyze usage of tables and possibly fields of a data warehouse. Does anyone have ideas of where I should look for a parsing routine that would pull out the various "selectable" objects from sql queries? Some of the queries will have pretty complicated and nested logic. The queries are all oracle-based. I could potentially use a dictionary approach, but I would rather not maintain a dictionary and instead just parse the SQL.


This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.