Win a copy of Java Mock Exams (software) this week in the Programmer Certification (OCPJP) forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

getting the list of table from msaccess database

 
ratna prasad kakani
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Ranch Hand
Posts: 1141
1
Java Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Greenhorn
Posts: 9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
use it like this:

[ July 23, 2003: Message edited by: jiayu gao ]
 
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!