On Sat, 11 Nov 2017 11:04:37 +0000, Bart Smissaert
<bart.smissa...@gmail.com> wrote:

> What are the exact rules for valid identifier names (tables, columns and
> indexes)?
> 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.
> Had a good look for this, but couldn't find a clear answer.

It conforms to the SQL standard, you can use the Postgresql docs
as a reference.

https://www.postgresql.org/docs/7.1/static/sql-syntax.html#SQL-SYNTAX-IDENTIFIERS

If you want to use a keyword (or an otherwise invalid word) as
an identifier, you have to quote it. SQLite has its own lost of
keywords.
https://sqlite.org/lang_keywords.html

-- 
Regards,

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

Reply via email to