This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC and the fly likes DatabaseMetaData API Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "DatabaseMetaData API" Watch "DatabaseMetaData API" New topic

DatabaseMetaData API

VenuGopal Reddy

Joined: Mar 06, 2007
Posts: 2
I want to display all the meta data information like,

1.List Of Tables
2.List Of Columns for in a table
3.Constraints on columns and tables
4.Primary Keys
5.foreign Keys...

i tried in the followimg way....

DatabaseMetaData metadata=con.getMetaData();
ResultSet rs=metadata.getTables(null,"Schema","*",null);

from this point i could not proceed further...

Please let me know code examples for this meta data or let me know how to proceed further...

suggesting any specific books with code examples related to meta data wud be helpful for me..

Thanks In Advance..
Eric Gero
Ranch Hand

Joined: Jul 20, 2005
Posts: 73
You can get the table names as follows:

DatabaseMetaData dbmd = dbConn.getMetaData();
ResultSet rsTables = dbmd.getTables(server.getInitialCatalog(), null, null, null);
String tableType = null;

while ( {
tableType = rsTables.getString("TABLE_TYPE");
if (tableType.equals("TABLE")) {
tableListModel.add(tableCount, rsTables.getString("TABLE_NAME"));

This link has a pretty good explanation of it.

VenuGopal Reddy

Joined: Mar 06, 2007
Posts: 2
Thanks Very Much Eric...Will go thru the link you have suggested...
subject: DatabaseMetaData API
Similar Threads
Memory Leaks
hibernate, mapping using discriminator - need idea
Unexpected tables in list
how to retrieve the table list in Access database through JDBC?
Review of my first Session EJB bean for best practice