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 wrote: > >> -Ursprüngliche Nachricht- >> em...@n0code.net wrote: >>> I’ve scoured the archives and the sqlite documentation but can’t find >>> the definitive rules for defining table and column names. >> >>

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

>-Ursprüngliche Nachricht- >em...@n0code.net wrote: >> I’ve scoured the archives and the sqlite documentation but can’t find >> the definitive rules for defining table and column names. > >Everything is allowed, except names beginning with "sqlite_". > This calls for a (not quite) OT

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 wrote: > > em...@n0code.net wrote: >> I’ve scoured the archives and the sqlite documentation but can’t find the >> definitive rules >> for defining table and column names. > > Everything is

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

em...@n0code.net wrote: > I’ve scoured the archives and the sqlite documentation but can’t find the > definitive rules > for defining table and column names. Everything is allowed, except names beginning with "sqlite_". > I did see we can’t use keywords The documentation disagrees:

[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