does Progress DB have system tables?

[leo2008]

could anyone tell me if the DB has system tables to store the table columns, indexes, foreign referencial keys? Thanks in advance

 

[KnutHandsome]

Data Dictionary > View > Show Hidden Tables.

Tables begin _

There's an article that describes them somewhere, but I can't find it at the mo.

Search for "metaschema" also.

 

[KnutHandsome]

Data Dictionary > View > Show Hidden Tables.

Tables begin _

There's an article that describes them somewhere, but I can't find it at the mo.

Manuals > Data Management > Database Admin > Virtual System Tables:

But note the difference between VSTs (activity tables) above and the metaschema documented in an old (and probably out of date, but may give you some ideas) paper here:

http://www.peg.com/techpapers/monographs/schema/schema.html

 

[comatt1]

Also, depending on the version of Progress you have right now. The newer version of Progress have significantly more system tables that allow you to gather more helpful information.