aspose file tools*
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 EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "DatabaseMetaData API" Watch "DatabaseMetaData API" New topic
Author

DatabaseMetaData API

VenuGopal Reddy
Greenhorn

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 (rsTables.next()) {
tableType = rsTables.getString("TABLE_TYPE");
if (tableType.equals("TABLE")) {
tableListModel.add(tableCount, rsTables.getString("TABLE_NAME"));
tableCount++;
}
}

This link has a pretty good explanation of it.
http://members.aol.com/kgb1001001/Articles/JDBCMetadata/JDBC_Metadata.htm

Eric
VenuGopal Reddy
Greenhorn

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