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