Re: [MonetDB-users] how to find the foreign key relationships

Gijs, On 14-06-2012 10:27:13 +0000, Molenaar, Gijs wrote:

I have the same problem for finding out which field is the primary key. I now have:

select k.name as key, t.name as tablename from sys.keys as k, sys.tables as t where k.type=0 and k.table_id = t.id;

Should I stringparse the key field for finding out the column name?

Perhaps you can "borrow" some code from JDBC and clients/mapiclient/dump.c Fabian