How to get list of tables from MySQL using Java DatabaseMetaData?

Question

DatabaseMetaData metadata = con.getMetaData();
metadata.getTables(catalog, schemaPattern, tableNamePattern, types);

What fields are required to get a list of tables?

+2

ScArcher2 21 Aug At 18:08

1 answer

Rob di marco · Accepted Answer · 2009-08-21T18:19:45+0000

If you want a list of all tables, you should use:

metadata.getTables(null, null, null, new String[]{"TABLE"});