Thomas Fischer said: > > On Tue, 19 Feb 2008, Fran Ferri wrote: > > > > Why the columnmap only supports one related column? > > Is an update pending? > > It seems that this particular information in ColumnMap does not support > multiple foreign key relations per column. But as this information is > not > used anyway, this has not been much of a problem in the past. There are > currently no plans to change this behaviour. >
I'm not even sure why this is needed? AFAIK, the SQL standards specifies: The foreign key identifies a column or a set of columns in one (referencing) table that refers to a column or set of columns in another (referenced) table. The columns in the referencing table must be the primary key or other candidate key in the referenced table. The values in one row of the referencing columns must occur in a single row in the referenced table. I'd interpret this as each column can only have one matching column in a single remote table. If you want the "ordering" for the remote tables' primary key set, you can get that by looking at the remote table's information. But I could be wrong about in this. I'd be curious to see the SQL that would define the multiple foreign key on one column. And then to see how many of the common Database servers support it. DukeCE Privacy Statement: Please be advised that this e-mail and any files transmitted with it are confidential communication or may otherwise be privileged or confidential and are intended solely for the individual or entity to whom they are addressed. If you are not the intended recipient you may not rely on the contents of this email or any attachments, and we ask that you please not read, copy or retransmit this communication, but reply to the sender and destroy the email, its contents, and all copies thereof immediately. Any unauthorized dissemination, distribution or copying of this communication is strictly prohibited. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
