Hi Ronald, Both the JDBC and ODBC code are able to produce this data. Have you looked into that code at the SQL queries? For JDBC you find them in sql/src/jdbc/nl/cwi/monetdb/jdbc/DatabaseMetaData.java. Regards On 19-09-2006 14:13:45 +0200, Ronald Oussoren wrote:
Hi,
I'm trying to build a driver for monetdb for sqlalchemy (a python ORM layer). One of the things I need to do for that is provide a way to reconstruct the (some of) database schema on the fly.
It seems to be easily possible to reconstruct most of the table definition from the 'table' and 'columns' tables, but how do I retrieve key contraints?
Specifically, given this table definition:
create table test ( id integer primairy key, name varchar(10) )
, I get some data in the keycolums table, but don't know how to relate that to the tables and colums tables.
I also need something simular for foreign keys, but haven't looked into that yet.
Ronald
P.S. I'm using the head of the CVS trunk.
------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys -- and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users