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

[saswat rashmi]

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]

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]

SQL Command = "SHOW TABLES"

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.