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

14 Jun 2012

      Hi monetdb people,

How do I find all foreign key relationships with MonetDB using SQL?

I now have:

"select idxs.name, tables.name from sys.tables, sys.idxs where tables.id = idxs.table_id and idxs.type=1;"

But that doesn't give me the related table. Any suggestion? I can't find documentation of the sys tables on the website, does it exist?

Thanks,

--
Gijs Molenaar
http://www.astro.uva.nl/people/gijs-molenaar/

Molenaar, Gijs