An easy way to get a list of all tables and fields in a database, sorted by their ID numbers, is to use SQL to query the system tables, like this:

Begin SQL SELECT TABLE_NAME, TABLE_ID, COLUMN_NAME, COLUMN_ID FROM _USER_COLUMNS ORDER BY TABLE_ID, COLUMN_ID INTO :lbox1 End SQL

Here the information is put into a listbox on a form:



For more information on using SQL in 4D, see the 4D SQL Reference at:

https://www.4d.com/docs/QLC/QLCMDUS.HTM.