How to find out the table names

Status
Not open for further replies.

kevin_w

Member
OK


I'm just started to learn progress (see previous messages), i wanna know how to get a list of the table-names that are used in my database, i have try this with the command "prostrct list (db-name), but then i've been told that the database is not a multi-volume database. So anyone can tell me how i can get a list of all the tables used in the database ?? I have only a *.db and *.bi file in my program directory.
 

Storzum

Member
Open a procedure window, connect to the db and type this:

FOR EACH ***._file:
display _file._file-name.
END.


*** is the name of the db
 

jongpau

Member
Or use the Progress Data Dictionary. If you have a windows setup youshould have a data dictionary item in your Progress Program Group inwindows. Start that, connect the database you refer to and you will beable to see all the tables, fields etc. The Data Dictionary alsoincludes some reports you can run to the printer so you get a papercopy of your database layout

BE CAREFUL: If and when you use the dictionary, do not changeany tables unless you know what you are doing, or your application mayfall over and die (and at the least require recompiling).
 
Status
Not open for further replies.
Top