Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

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

 
saswat rashmi
Greenhorn
Posts: 14
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 10336
Eclipse IDE Hibernate Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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).
 
Muhammad Saifuddin
Ranch Hand
Posts: 1324
Android Java Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator


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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic