Table and Columns Query

[superfly18]

Hello:

I was wondering if there was some kind of simple query i can run on Progress, when querying through ODBC to get a list of all of the tables and columns in the database?

 

[tamhas]

_file and _field, joined by recid(_file)

 

[superfly18]

I'm sorry I dn't understand. Shouldn't it start with 'SELECT' if I am running it through ODBC?

 

[tamhas]

Yes. I am providing the information needed, not the actual query.

 

[medu]

_file and _field, joined by recid(_file)

afraid you can't get the table recid in SQL, there are view's created just for that in sysprogress schema...

select * from SYSTABLES t, SYSCOLUMNS c where c.tbl = t.tbl