On 19 Mar 2016, at 10:30am, 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. It may work fine for that statement but you may find that it causes problems later. For instance once you've created a column called 'abort' the command CREATE TRIGGER ON myTable WHEN abort ... may not do what you expect it to do. (I don't know that that specific example is a problem, I'm just illustrating.) So even if one of the words in that list works in one context it's better to avoid it. Simon.
