G
Guest
Hi;
Please, please, please tell me there is a way to do this.
For a foreign key, say Orders.CustomerId I need to know that it maps to
Customers.CustomerId. I need to be able to get this metadata both from when I
first read all the tables & views from a database and more critically, when I
do a select and get a result set back - get this info for each FK column in
the returned table.
How can I do this. Preferably vendor independently but if I have to, we can
write specific code for Sql Server, Oracle, DB2, and MySql.
--
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com
Cubicle Wars - http://www.windwardreports.com/film.htm
Please, please, please tell me there is a way to do this.
For a foreign key, say Orders.CustomerId I need to know that it maps to
Customers.CustomerId. I need to be able to get this metadata both from when I
first read all the tables & views from a database and more critically, when I
do a select and get a result set back - get this info for each FK column in
the returned table.
How can I do this. Preferably vendor independently but if I have to, we can
write specific code for Sql Server, Oracle, DB2, and MySql.
--
thanks - dave
david_at_windward_dot_net
http://www.windwardreports.com
Cubicle Wars - http://www.windwardreports.com/film.htm