Field and Table Names
  • 1 Minute to read
  • Dark
    Light
  • PDF

Field and Table Names

  • Dark
    Light
  • PDF

Article summary

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


Was this article helpful?

What's Next