Column Names
[Previous] [Main] [Next]

Column names have to be valid identifiers. That means they may contain up to 40 characters, digits and the special characters _ and -. The first character of a column name must not be a digit. Spaces are not allowed but German umlauts are. To illustrate these rules we show a list of examples of valid and invalid column names.

Valid column names are:
Name
Age
Street
Avarage_Duration
Date-of-birth
Address8
Lösung

These are examples of invalid column names:
No of Items(spaces not allowed)
Very_long_name_exceeding_the_40_characters_limit (48 characters is too long)
3645 (first character must be non-digit)

Note: Because hyphens are allowed in identifiers, expressions like n1-n2 are interpreted as an identifier. You must insert at least one space to make the difference: n1 - n2 avoids this problem.