[email protected] wrote:
> I’ve scoured the archives and the sqlite documentation but can’t find the 
> definitive rules
> for defining table and column names.

Everything is allowed, except names beginning with "sqlite_".

> I did see we can’t use keywords

The documentation disagrees: http://www.sqlite.org/lang_keywords.html

CREATE TABLE "TABLE"("#!@""'☺\", "");  -- keyword, special characters, empty 
name


Regards,
Clemens
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to