Field and Table Names

  • 1 minute(s) read

Field and Table Names

Case Sensitivity

Field and table names are CASE SENSITIVE.   A script that uses [transaction] for the [Transaction] table will generate an error.

It is possible to have the following fields on the same table at the same time:

  • [Table1].[Field]
  • [Table1].[field]
  • [Table1].[FIELD]

Valid characters

The following characters are valid for field or table names:

[space]abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789_-%()£$!@:&

Field and table names must be 2 or more characters in length