getting the list of table from msaccess database

[ratna prasad kakani]

hello,
i want to get the list of table from msaccess database,simply like "select * from tab" in oracle. if possible pls help me else is there any other way pls say to me

[Avi Abrami]

Hi Ratna,
Excuse me if I am stating the obvious, but you can use the DatabaseMetaData interface. Works for me on my Windows98 machine with J2SE SDK 1.4.1 (using the JDBC-ODBC driver that is included with the SDK) and Micro$oft Access 2000.
Good Luck,
Avi.

[ratna prasad kakani]

thanks avi,
my system is windows 2000 i had used databasemetadata but i am not getting the table name except that database name and its class path

[jiayu gao]

use it like this:

  
......
DatabaseMetaData dd=conn.getMetaData ();

String[] types={"TABLE"};
ResultSet t=dd.getTables (null,null,null,types);
while(t.next ()){
System.out.println (t.getString ("TABLE_NAME"));
        //getString("TABLE_NAME") is important
}
.......

[ July 23, 2003: Message edited by: jiayu gao ]