On 3/19/16, Paul Sanderson <sandersonforensics at gmail.com> wrote: > Is there a list of reserved column names > > I have seen the list or keywords at the link below > > http://www.sqlite.org/lang_keywords.html > > but for instance create table (abort int) will work fine. >
There is no list. The "official" position is that keywords should never be used as identifiers. Ever. SQLite is very forgiving on this point. It will tolerate the use of many keywords as identifiers in many different contexts. (The Lemon parser generator contains special logic to handle this case.) This grace from the parser is to maximize backwards compatibility. But you should not count on it. If an identifier is a keyword, or looks like something that might someday become a keyword, then you should quote it. -- D. Richard Hipp drh at sqlite.org
