KNOWLEDGE BASE
Log In    |    Knowledge Base    |    4D Home
Tech Tip: Do not modify 4D system tables programmatically
PRODUCT: 4D | VERSION: 11.6 | PLATFORM: Mac & Win
Published On: April 2, 2010

Developers can use system tables to get information regarding database structures. They cannot write or change information in the system tables. For example the following code will generate a runtime error:

Begin SQL
  UPDATE _USER_TABLES
  SET TABLE_NAME = 'Company'
  WHERE TABLE_ID = 2
End SQL


Of course, if you edit the structure via the 4D Structure Editor or by adding tables in SQL then the system tables update accordingly.