Getting metadata from any database ?

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Stef Mientki

    Getting metadata from any database ?

    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
Working...