Systemtables

[marco]

Hallo,
I have a question. What is the name form the system tables in Progress? I will connect progress with ODBC and I need the names form all tables in the database with using SQL.

Thanks Marco.

 

[Norman Biggar]

You can get a complete list of Table names on a database by looking at the _File-name field of the _File table.
The system tables are identified as having an _File-number less than 0 or greater than 32000

 

[marco]

That's great. Thank you.
Now I need all field from a table. Can you help me?
--
Marco

 

[Norman Biggar]

You want to look at the _Field table. It is one of the system tables you should have seen when querying on _File.

FOR EACH _File,
EACH _Field OF _File.......

 

[marco]

Thank's but I need a SQL - Query!

 

[JonMeecham]

Try this.....

SELECT _file._file-name, _field._field-name FROM _file, _field.

This should give a list of table fields.