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?
Asked
Active
Viewed 36 times
0
Carbon
- 3,054
- 1
- 21
- 43
-
Regex? `"([A-Za-z]+)\."` – cacti5 Mar 09 '18 at 21:14
-
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
-
Needs to be a domain specific sol'n – Carbon Mar 09 '18 at 21:15
-
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
1 Answers
1
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.
John Wu
- 47,831
- 8
- 41
- 73