[Chicago] How to get table names from ODBC?

Lukasz Szybalski szybalski at gmail.com
Fri Aug 3 17:24:30 CEST 2007


Hello,
I am using python win32 extentions.

I get connected via odbc to a database files that are sitting in the folder.

import dbi,odbc
db=odbc.odbc('dbfiles')
cursor=db.cursor()
cursor.execute('select * from tableabcd')
print  cursor.description

This way I am able to find column names.
How do i find a available table names?  I have 20 tables available to
me. How do I list their names??

Lucas


More information about the Chicago mailing list