GetTableList Funktion of Table

[boyi01]

Hey,

i want to analyze sqls regarding from which table there reading and to which table there writing (changing stuff).

is there any possiblity to geht these information with JSqlParser?

[manticore-projects]

Greetings.

Yes, this can be achieved with JSQLParser:

1. Tables to be written to would be found in INSERT, MERGE, UPDATE, DELETE and TRUNCATE TABLE statements
2. Tables to be read from would be found in SELECT statements and JOIN fragments

Best regards
Andreas