Re: [sqlite] What are the rules for defining names for tables and columns?

:) Roger that. > On Mar 27, 2017, at 10:58 AM, Hick Gunter <h...@scigames.at> wrote: > >> -Ursprüngliche Nachricht- >> em...@n0code.net wrote: >>> I’ve scoured the archives and the sqlite documentation but can’t find >>> the definitive

Re: [sqlite] What are the rules for defining names for tables and columns?

Wow! Ok - awesome! Thanks! > On Mar 27, 2017, at 10:45 AM, Clemens Ladisch <clem...@ladisch.de> wrote: > > em...@n0code.net wrote: >> I’ve scoured the archives and the sqlite documentation but can’t find the >> definitive rules >> for defining table

[sqlite] What are the rules for defining names for tables and columns?

Hi, I’ve scoured the archives and the sqlite documentation but can’t find the definitive rules for defining table and column names. I did see we can’t use keywords and tables can not begin with sqlite_. Are there others? What characters can we use? Is it the same as MySQL? Thanks, Eric