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?

Rob Di Marco · Accepted Answer · 2009-08-21 18:19:45Z

5

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

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

answered Aug 21, 2009 at 18:19

Rob Di Marco

45.3k9 gold badges73 silver badges58 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

For clarity, table names will en up in resultSet.getString(3)