4D Doc Center : GET MISSING TABLE NAMES

Home

4D v14.3

GET MISSING TABLE NAMES


GET MISSING TABLE NAMES ( missingTables )

Parameter	Type	Description
missingTables	Text array	Names of missing tables in the database

Description

The GET MISSING TABLE NAMES command returns the names of all the missing tables of the current database in the missingTables array.

Missing tables are tables whose data are present in the data file but that do not exist at the level of the current structure. This can happen when a data file is opened with different versions of the structure.

Typically, the scenario is as follows:

The developer provides a structure containing tables A, B and C,
The user adds the custom tables D and E, using, for example, the integrated commands of 4D, and stores data in these tables,
The developer provides a new version of the structure. It does not contain tables D and E.
In this case, the user version of the database still contains data from tables D and E, but it cannot be accessed. The GET MISSING TABLE NAMES command will return the names "D" and "E".

Once you have identified the missing tables of the database, you can reactivate them via the REGENERATE MISSING TABLE command.

Note: The data of missing tables are erased when the data file is compacted (if the tables have not been regenerated).