Not enough sleep, need schema help

[JustMe]

Not enough sleep I guess, I need schema help, I would like to automate some importing to the progress database. What I need is a way to get any specific table's fields and data-types. I found the _tables and _fields files but there doesn't seem to be a way to tie them together (I know that isn't true because the DB does it). I can see the DB Details view which is what I need but from a programs side. I have build something similar in mySQL but am falling short here.

sample of what I would like to do (yes this one is in SQL): select pub."_Db-Detail".* from PUB."_Db-Detail";

As always any and all help is appreciated!

 

[Stefan]

_field has an _file-recid field - this points to the recid of _file - this is annoying to do with sql92, so some views are available that do this.

See http://www.progresstalk.com/showthread.php?118477-Table-and-Columns-Query&highlight=view+_file

 

[JustMe]

Thanks, I think that should work!
Take two prizes off of the top shelf :-D

JustMe