rs = metaData.getImportedKeys(catalog, schema, name); while (rs.next()) { ForeignKey fk = new ForeignKey(); foreignKeys.add(fk); fk.setOwner(this); fk.setPkTableCatalog(rs.getString("PKTABLE_CAT")); fk.setPkTableSchema(rs.getString("PKTABLE_SCHEM")); fk.setPkTableName(rs.getString("PKTABLE_NAME")); fk.setPkColumnName(rs.getString("PKCOLUMN_NAME")); fk.setColumnName(rs.getString("FKCOLUMN_NAME")); fk.setKeySequence(rs.getShort("KEY_SEQ")); fk.setUpdateRule(rs.getShort("UPDATE_RULE")); fk.setDeleteRule(rs.getShort("DELETE_RULE")); fk.setName(rs.getString("FK_NAME")); fk.setPkName(rs.getString("PK_NAME")); fk.setDeferrability(rs.getShort("DEFERRABILITY"));
ForeignKey fk = i.next(); out.print(" "); if (fk.getName() != null) out.print("CONSTRAINT " + fk.getName() + " "); out.print("FOREIGN KEY (" + fk.getColumnName() + ") REFERENCES " + fk.getPkTableName()); if (fk.getPkColumnName() != null) out.print(" (" + fk.getPkColumnName() + ")"); if (i.hasNext()) out.println(',');
DbAttribute targetAttribute = join.getTarget(); if (targetAttribute.isPrimaryKey()) { ForeignKey fk = new ForeignKey(); fk.setPkTableCatalog(target.getCatalog()); fk.setPkTableSchema(target.getSchema()); fk.setPkTableName(target.getName()); fk.setPkColumnName(targetAttribute.getName()); fk.setColumnName(join.getSourceName()); fk.setKeySequence(keySequence++); table.addForeignKey(fk);
table.addPrimaryKey(pk); ForeignKey fk = new ForeignKey(fkColumn); fk.setPkColumnName(pkColumnName); fk.setPkName(pkName); fk.setPkTableCatalog(catalog); fk.setPkTableName(referencedTableName); fk.setPkTableSchema(schemaName); table.addForeignKey(fk);
DbAttribute targetAttribute = join.getTarget(); if (targetAttribute.isPrimaryKey()) { ForeignKey fk = new ForeignKey(); fk.setPkTableCatalog(target.getCatalog()); fk.setPkTableSchema(target.getSchema()); fk.setPkTableName(target.getName()); fk.setPkColumnName(targetAttribute.getName()); fk.setColumnName(join.getSourceName()); fk.setKeySequence(keySequence++); table.addForeignKey(fk);