File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Listing out tables in a database

 
Suma K Gowda
Greenhorn
Posts: 12
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi

I'm connecting to a database and want to display all the available tables under that database. How can I do it?

I checked the whole java.sql api..but didn't find anything which actually displays the tables under a database..

Plz help
 
Paul Sturrock
Bartender
Posts: 10336
Eclipse IDE Hibernate Java
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
All the metadata functionality of JDBC is supplied by jav.sql.DatabaseMetaData. If there's nothing in there to do what you want, you'll have to resort to the verdor-specific queries for doing this ("show tables" in mysql, "select * from user_tables" in Oracle, "select * from sysobjects where xtype ='U'" in MSSQL etc.)

[ June 11, 2004: Message edited by: Paul Sturrock ]
[ June 11, 2004: Message edited by: Paul Sturrock ]
 
Peter den Haan
author
Ranch Hand
Posts: 3252
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Exactly.Will give you all tables and views in a given schema. See the javadoc for further information on the metadata API. For a detailed discussion, the standard recommendation is the excellent The JDBC API Tutorial and Reference (reviewed in the Bunkhouse; I should add that as one of the tech reviewers on this book I'm not unprejudiced).

- Peter
[ June 11, 2004: Message edited by: Peter den Haan ]
 
I agree. Here's the link: http://aspose.com/file-tools
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic