table Names

[jb er]

Hi,
Iam new to db.
So can some one tell me how I can get all the table names in a database.
I need it to create a jtree.
I know to get columns of a particulsr table using resultsetmetadata.
Can someone help.
J

[Lasse Koskela]

Try the following piece of code:

import java.util.Collection;
import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.ResultSet;
...
/**
 * Returns a Collection of tables available via the given Connection.
 */
public static Collection getTableNames(Connection c) {
    Collection tableNames = new ArrayList();
    DatabaseMetaData dbmetadata = c.getMetaData();
    ResultSet rset = dbmetadata.getTables(null, null, null, null);
    while (rset.next()) {
        tableNames.add(rset.getString("TABLE_NAME"));
    }
    return tableNames;
}