Getting metadata from any database ?

[Stef Mientki]

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