How to get database metadata information (i.e. existing tables and columns in tables)

[Miki]

Hello Chris,

> Is it possible to retrieve details about the database, specifically a
> list of the tables in the database; and then to retrieve the columns
> and their types for the tables?
>
> Is this dependant on the database?
Yes and Yes. However some toolkits like SQLObject
(http://www.sqlobject.org/) and SQLAlchemy (http://www.sqlalchemy.org/)
can do this work for you (IIRC).

HTH,
Miki
http://pythonwise.blogspot.com/