how do i list tables in a database?

[amnesia]

seems like this should be the simplest thing in the world, but i can't for the life of me figure out how to list all of the tables in a particular database. i'm connecting to Progress 8.3B using ODBC (perl dbd:dbc), using openlink multitier uda. in mysql, there is a 'show tables' command, but i cannot seem to find any equivalent that will work with progress. any help is appreciated!

 

[mloya]

Should work...

Select * from sysprogress.systables

OR

Select * from sysprogress.systables where left(tbl,3) <> 'SYS' and left(tbl,1) <> '_'

...if you want to ommit listing tables from Progress System.