How do I parse a SQL query to determine its tabular depencencies?

Question

Assume I have a query, eg:

SELECT * FROM POTATO LEFT JOIN TUBER ON POTATO.delicious = TUBER.delicious

Is there a library or tool that will take that query and return ["POTATO,"TUBER"], such that I can sequence a series of queries logically?

Can't assume that there'll be a dot. You can also do `SELECT * FROM POTATO b LEFT JOIN TUBER a ON a.delicious = b.delicious` — Carbon, Mar 09 '18 at 21:14
Similar topic [sql-parser-library-for-java-retrieve-the-list-of-table-names-present-in-a-sql](https://stackoverflow.com/questions/5572793/sql-parser-library-for-java-retrieve-the-list-of-table-names-present-in-a-sql) — David Abragimov, Mar 09 '18 at 21:22

score 1 · Accepted Answer · answered Mar 09 '18 at 21:15

Probably the easiest thing to do is execute the SQL with SET STATISTICS XML ON. When you do that, you'll get two resultsets: the resultset of the query and a resultset containing the query plan as XML, contained as the first column in the last row.

Once you have the query plan as XML, follow these instructions to get a list of all the attributes, then filter for "Table" and inspect the results.

How do I parse a SQL query to determine its tabular depencencies?

1 Answers1