public ResultSet getCrossReference
(String primaryCatalog,
String primarySchema,
String primaryTable,
String foreignCatalog,
String foreignSchema,
String foreignTable)
Question:
How (if at all) should referential constraints involving unique constraints be reflected in the ResultSet produced by getCrossReference?
-- Omit them entirely?
-- Include them, but show the Primary Key columns of the Parent table rather than those of the Unique Constraint?
-- Include them, and show the Unique Constraint columns instead of the Primary Key columns?
-- Include BOTH of the last two CrossReferences, although only the last
seems really useful?
###@###.### 2004-02-02
(String primaryCatalog,
String primarySchema,
String primaryTable,
String foreignCatalog,
String foreignSchema,
String foreignTable)
Question:
How (if at all) should referential constraints involving unique constraints be reflected in the ResultSet produced by getCrossReference?
-- Omit them entirely?
-- Include them, but show the Primary Key columns of the Parent table rather than those of the Unique Constraint?
-- Include them, and show the Unique Constraint columns instead of the Primary Key columns?
-- Include BOTH of the last two CrossReferences, although only the last
seems really useful?
###@###.### 2004-02-02