Java Program to List Tables and Their Relationships in Database

Posted on November 6, 2008. Filed under: Uncategorized | Tags: Database, Mysql |

Here is sample Java Program to List all Tables and their relationships in database

/**
*
*/
package com.research.sql;
import java.sql.Connection;
import java.sql.DatabaseMetaData;
import java.sql.ResultSet;
import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;
/**
* @author Ashwin
*
*/
public class ObjectGrapher {
/**
* @param args
*/
public static void main(String[] args) {
try {
Connection con = DBUtils.getConnection();
DatabaseMetaData metaData = con.getMetaData();
ResultSet rs = metaData.getTables(null, null, “%”, null);
List tableNamesList [...]