Tech Tip: How to get all visible and non-visible table titles and numbers

PRODUCT: 4D | VERSION: 20 | PLATFORM: Mac & Win

Published On: September 12, 2023

When trying to get all table titles and numbers, typically the GET TABLE TITLES command would be used. However, this command does not include invisible tables. To bypass this issue, SQL can be used instead which will include all visible and non-visible tables.

ARRAY TEXT($tableNames; 0)
ARRAY LONGINT($tableNums; 0)

Begin SQL
SELECT TABLE_ID, TABLE_NAME FROM _USER_TABLES
INTO :$tableNum, :$tableNames;
End SQL