On 11 Nov 2017, at 11:04am, Bart Smissaert <bart.smissa...@gmail.com> wrote:

> What are the exact rules for valid identifier names (tables, columns and
> indexes)?

There is no documentation for this.  Which means that even if you find that, 
say, macrons are allowed in this version, they might not be allowed in the next 
version.

> This is both for names enclosed in square brackets ([]) or double quotes
> (") and also for names
> that are not enclosed within square brackets or double quotes.

Please note this distinction:

A) The names Col1 and "Col1" are both allowed and refer to the same entity.

B) The names Col1 and "Col1" are both allowed and refer to different entities.

Some SQL engines do one, some do the other.

Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to