TurboDB Engine Documentation

Table and Column Names

Previous  Top  Next

Identifiers

Identifiers consist of a true character followed by alphanumeric characters, the underscore _ and the hyphen. They can contain up to 40 characters. German umlauts count as true characters.

Valid identifiers are:

Street
Avarage_Duration
Date-of-birth
Address8
Lösung

Column and Table Names

Column and table names can contain any ANSI characters but the control characters, the brackets [] and the double quotes. The maximum length is 40 and it must start with a real character. If the name follows the rules for an identifier, it can be used normally in all expressions and statements. If it does not, it must be included either in double quotes or in brackets.

These are examples of invalid identifiers, which can be used as column names if enclosed in double quotes or brackets:

No of Items (spaces not allowed)
3645 (first character must be non-digit)