Yeah, thanks, I'm using Oracle on Linux (for which I can interrogate the USER_TABLES or ALL_TABLES as well as DESCRIBE - from memory), and ODBC on WIN32. AFAIK there's no counterpart to DESCRIBE for ODBC but you have to rely on lower level ODBC functions to obtain column names, descriptions, etc. This info should be available to Zope and I'd prefer to get it from there if at all possible, for purposes of RDBMS independence and portability. I also require transactions, which AFAIK puts mySQL out of the picture. AN -----Original Message----- From: darryl@igor.penguinpowered.com [mailto:darryl@igor.penguinpowered.com] Sent: Wednesday, 12 January 2000 4:55 To: Nerlich, Andrew Subject: Re: [Zope] Obtaining column names when using ZSQL method You should be able to get that columns and col types in you SQL Method. I am using mysql and this works: describe tablename -D