Extracting DB schemas/table definitions from ODBC database

[Huy Do]

"Aahz Maruch" <aahz at netcom.com> wrote in message
news:8erv7l$mtv$1 at slb0.atl.mindspring.net...
> In article <TdfQ4.11202$v85.73530 at news-server.bigpond.net.au>,
> Huy Do <huy at nsw.bigpond.net.au> wrote:
> >
> >I am trying to extract the database schema(table definitions/structure)
> >i.e table names, field names, field data types etc. from an ODBC
> >database (eg. sql server) using mxODBC and iODBC. I am developing on a
> >Linux box and the database server is an NT box (inconsequential).
>
> You need to use the system catalog.  Look up INFORMATION_SCHEMA.
> --

Yes, just what i was looking for....

Thank you Aahz