Ken wrote: > The following errors out: > > CREATE TABLE users ( > user# INTEGER NOT NULL, > name VARCHAR(30) NOT NULL, > PRIMARY KEY (user#) > ) ; > > SQL error: unrecognized token: "#" > > It appears that $ is allowed, is there a technical reason why # is ommitted > from valid tokens? >
Ken, Standard SQL only allows letters, digits, and underscores in identifiers. If you need to use other characters, like a space or a '#', you need to quote the identifier using double quotes. Try "user#" instead of user# and you will be set. HTH Dennis Cote _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users