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

Tue Aug 22 09:41:42 EDT 2006

Chris Brat wrote:
> Hi,
> 
> 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? 
> 
As far as locating the field names goes, this should work with most 
DBAPI modules:

http://aspn.activestate.com/ASPN/Cookbook/Python/Recipe/81189

thought hat doesn't help wiht getting the table names ...

regards
  Steve
-- 
Steve Holden       +44 150 684 7255  +1 800 494 3119
Holden Web LLC/Ltd          http://www.holdenweb.com
Skype: holdenweb       http://holdenweb.blogspot.com
Recent Ramblings     http://del.icio.us/steve.holden