String sql = "select constraint_name,table_name,column_name,referenced_table_name,referenced_column_name from information_schema.KEY_COLUMN_USAGE where constraint_schema='"
+ db + "' and table_name='" + tablename + "'";
List<CmsConstraints> constraints = new ArrayList<CmsConstraints>();
SqlRowSet set = getJdbcTemplate().queryForRowSet(sql);
while (set.next()) {
CmsConstraints constraint = new CmsConstraints();
constraint.setName(set.getString(1));
constraint.setTableName(set.getString(2));
constraint.setColumnName(set.getString(3));
constraint.setReferencedTableName(set.getString(4));
constraint.setReferencedColumnName(set.getString(5));
constraints.add(constraint);
}
return constraints;
}