Example Depot

try { // Gets the database metadata DatabaseMetaData dbmd = connection.getMetaData(); // Specify the type of object; in this case we want tables String[] types = {"TABLE"}; ResultSet resultSet = dbmd.getTables(null, null, "%", types); // Get the table names while (resultSet.next()) { // Get the table name String tableName = resultSet.getString(3); // Get the table's catalog and schema names (if any) String tableCatalog = resultSet.getString(1); String tableSchema = resultSet.getString(2); } } catch (SQLException e) { }