[Chicago] How to get table names from ODBC?

[Tim Ottinger]

Isn't that database-dependent and not connection-mode dependent?
Every database has system tables, and they don't have standardize name and
schema across database vendors.
If there is a general way, i do not know it.



On 8/3/07, Lukasz Szybalski <szybalski at gmail.com> wrote:
>
> 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
> _______________________________________________
> Chicago mailing list
> Chicago at python.org
> http://mail.python.org/mailman/listinfo/chicago
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.python.org/pipermail/chicago/attachments/20070803/2082ee5c/attachment.htm