Table numbering
There are no hard and fast rules for table numbering, except that we must only use the table object numbers that we are licensed to use. If all we have is the basic Table Designer rights, we are generally allowed to create tables numbered from 50000 to 50009 (unless our license was defined differently from the typical one). If we need more table objects, we can purchase licensing for table objects numbered up to 99999. Independent Software Vendors (ISVs) can purchase access to tables in other number ranges to use for their add-on products.
When creating several related tables, ideally, we should assign them related numbers in sequential order. We should let common sense be our guide to assigning table numbers. It requires considerable effort to renumber tables containing data.
