Help

[Tom Ben]

How do you return the names of the tables in a given database? I am new to the jdbc and SQL database world come from UniData world.
------------------
Sun Certified Programmer on the Java 2 Platform

[Corey McGlone]

The key here is the use of the DatabaseMetaData object. That object allows you to find out all sorts of information about a database, including the database name, type, driver, table names, column names, types, etc. A lot of information is available.
The following code (which I haven't yet tested ) should be pretty close to what you need to get your table names and column names.

DatabaseMetaData dbmd = dbConnect.getMetaData();
ResultSet tables = dbmd.getTables(null, null, null, new String[] { "TABLE" });
while ( tables.next() )
{
   String name = tables.getString("TABLE_NAME");
   ResultSet indices = dbmd.getIndexInfo(null, null, name, false, false);
   while ( indices.next() )
   {
      System.out.println(indices.getString("COLUMN_NAME"));
   }
}

I hope this helps you out,
Corey

[Tom Ben]

Hey thanks. I am trying to connect to a Lotus Notes DB and it is not like mySQL.

[Bosun Bello]

As long as the DB is a relational DB, what corey posted should have got you all the tables in the DB. When you said it's not like mySQL, are you saying it's not a relational DB such as Oracle, DB2, MSAccess atc.?
------------------
Bosun
SCJP for the Java� 2 Platform

[Tom Ben]

I am connecting into the DB blindly and not very familiar with this style of DB I use a Multi-Valued DB.
Thanks Corey I will give this a shot and let you know.

Originally posted by Bosun Bello:
As long as the DB is a relational DB, what corey posted should have got you all the tables in the DB. When you said it's not like mySQL, are you saying it's not a relational DB such as Oracle, DB2, MSAccess atc.?

[Tom Ben]

it worked nicly thanks a lot!