File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JDBC and the fly likes What is the SQL command to list all tables in a access database(mdb)    Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "What is the SQL command to list all tables in a access database(mdb)    " Watch "What is the SQL command to list all tables in a access database(mdb)    " New topic
Author

What is the SQL command to list all tables in a access database(mdb)

saswat rashmi
Greenhorn

Joined: Jul 31, 2007
Posts: 14
hi everyone

can anybody tell me

how to retreive and display total number of tables or total table name

in a particular database in jsp page
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

Database access code in a JSP is not a good idea. Better to put this sort of stuff in a bean somewhere. Have a look at java.sql.DatabaseMetaData. This gives you a means to interogate the database (be aware though that not all drivers may implement all methods).


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
Muhammad Saifuddin
Ranch Hand

Joined: Dec 06, 2005
Posts: 1321



I used this SQL command in MySQL to display all my tables in particular database and its work fine for me, but I am not sure whether its works for you in Ms Access or not.

hope it helps.


Saifuddin..
[Blog][Linkedin] How To Ask Questions On JavaRanch My OpenSource
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: What is the SQL command to list all tables in a access database(mdb)