Getting metadata from any database ?

Question posted by: Stef Mientki (Guest) on July 5th, 2008 07:25 AM

hello,

I want to create a (local) database viewer for all databases,
it's working now for sqlite3 (python 2.5),
and I now want to get it working through odbc,
so I can manage most other databases.

In sqlite I can get the metadata (tables, stored views, procedures, etc)
through pragma statements.
Is there a similar way for odbc ?

(Couldn't find anything in API 2.0 specs)

(mxODBC is not option because my project is an open source project)

thanks,
Stef Mientki

Not the answer you were looking for? Post your question . . .
189,075 Experts ready to help you find a solution.
Sign up for a free account, or Login (if you're already a member).