When you delete a Table or a Field, the rest of the tables and fields of the database do not get renumbered.
Consequently, a database can contain tables and fields that are not numbered sequentially. In addition, when new Tables and Fields are added the numbers of deleted Tables and Fields are reused for the new ones.
Using the commands Count tables and Count fields no longer provides you with accurate information. These commands do not take into account the "holes" left in the sequences of Table and Field numbers left by deleting them.
New commands are now available in 4D v11 SQL to manage Table and Field numbers.
Count tables is now Get last table number and Count Fields is now Get last field number. In addition, there are two new commands Is table number valid and Is field number valid to count database Tables and Fields.
Get last table number
Get last field number
Is Table number valid
Is field number valid