TurboSQL Guide

Column Names

Previous  Top  Next

Like the ANSI-standard TurboSQL confines each column name to a single word comprised of alphanumeric characters and the underscore symbol "_". To distinguish similar column names from different tables preface the table name.

SELECT Employee_Id
FROM Employee

or

SELECT Employee.Employee_Id
FROM Employee

In addition, TurboSQL can use the German umlauts for column names and table names:

SELECT Kürzung
FROM Beiträge

For using column names that contain spaces or other special characters and for distinguishing column names from e.g. function names, you can enclose the column name in brackets or double quotes:

SELECT "Employee Id", [Employee Id]
FROM [Update]