How do I get a list of tables from MySQL using Java's DatabaseMetaData?

Question

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

What fields are required to get a list of tables?

Answer 1

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

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