Hello, You can use jOOQ's query object model API to extract all tables from your parsed queries: https://www.jooq.org/doc/latest/manual/sql-building/model-api/
It will be easiest to achieve using Traversers: https://www.jooq.org/doc/latest/manual/sql-building/model-api/model-api-traversal/ https://www.jooq.org/javadoc/latest/org.jooq/org/jooq/Traversers.html ... but it's also possible to do this manually I hope this helps, Lukas On Thu, Aug 21, 2025 at 3:26 PM tuk <subharaj.ma...@gmail.com> wrote: > We are using JOOQ with MySQL 8 for generating Java code. > > Can someone let me know if it is possible to also use JOOQ as a parser to > extract all table names referenced in a MySQL .sql file? The .sql file can > contain both DDL, DML statements. > > -- > You received this message because you are subscribed to the Google Groups > "jOOQ User Group" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to jooq-user+unsubscr...@googlegroups.com. > To view this discussion visit > https://groups.google.com/d/msgid/jooq-user/295226fc-b029-46aa-a446-9924c1dca87fn%40googlegroups.com > <https://groups.google.com/d/msgid/jooq-user/295226fc-b029-46aa-a446-9924c1dca87fn%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to jooq-user+unsubscr...@googlegroups.com. To view this discussion visit https://groups.google.com/d/msgid/jooq-user/CAB4ELO5MgLELUPxNPuNtYoie80CX1zz4BS1ypCQO%3DaBdvcUC%2Bg%40mail.gmail.com.
