community.borland.com

Article #25530: A Possible Cause of "Token Unknown SQL code 104" Errors When Creating Tables

Problem:
I am getting the message 

    Dynamic SQL Error
    -SQL error code = -104
    -Token unknown - line 1, char 13
    -names

when I try to create a table.  Here is my create syntax : 

    create table names (a char(1), b char(1))


Solution:

You are getting this error because you are using a keyword 
as a table name.  The word  "names" is a keyword in InterBase.   
For more information on keywords in InterBase, consult the 
Keywords chapter in InterBase Language Reference.		

Note:  A complete list of InterBase 5 keywords is on page 168 
of the InterBase 5.0 Language Reference book, in the chapter 
on "Keywords."

A list of keywords that are new in InterBase 5 is on page 23 
of the InterBase 5.0 Operations Guide, in the section on "Migrating 
from InterBase 4 to InterBase 5".


Last Modified: 26-OCT-00