String parentColumnName = tableFKResultset.getString("COLUMN_NAME"); //the column that is FK in the input table (ie parent column)
String childTableName = tableFKResultset.getString("REFERENCED_TABLE_NAME"); //the referenced table
String childColumnName = tableFKResultset.getString("REFERENCED_COLUMN_NAME"); //the child column referenced by the FK
TableFKconstraintsBean tableFKconstraintsBean = new TableFKconstraintsBean();
tableFKconstraintsBean.setParentTableName(parentTableName); //the parent table
tableFKconstraintsBean.setParentColumnName(parentColumnName);//the parentColumn
tableFKconstraintsBean.setReferencedTableName(childTableName);
tableFKconstraintsBean.setReferencedColumnName(childColumnName);
tableFKinfoBeanList.add(tableFKconstraintsBean);
}
}catch (Exception e) {