How can we get tablelist of a database using Hibernate?

Hi,

List tableList=ses.createSQLQuery("select tname from tab").list(); will return a list comprising of all the the table names in your schema.

Plese rate if found helpful.

Hi the above query will list both tables and views from the DB. If you want only the tables to be listed, then use the following query select tname from tab where tabtype='TABLE';