How to use criteria API to query schema details?

Asked Aug 13 '18 at 05:59

Active Aug 13 '18 at 07:55

Viewed 225 times

i have a query to find table details in MySQL using criteria API in hibernate Spring, like below to get 'Auto_increment' from table.

SELECT
  Auto_increment
FROM information_schema.tables
WHERE table_name = 'the_table_you_want';

My first question will be, is it possible to use criteria API to get information_schema details'?
How to put it in criteria API to get required result ? Because i googled it on this topic i didn't find anywhere, where criteria is used to find schema details.

edited Aug 13 '18 at 07:55

asked Aug 13 '18 at 05:59

daisy

take a look [How do I show the schema of a table in a MySQL database?](https://stackoverflow.com/questions/1498777/how-do-i-show-the-schema-of-a-table-in-a-mysql-database) – munsifali Aug 13 '18 at 06:55
@deadman i want how to do it using criteria api in java. – daisy Aug 13 '18 at 07:34
I doubt you can – Antoniossss Aug 13 '18 at 08:06

0 Answers0