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

2017-03-27 Thread em...@n0code.net 
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 
___
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

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

2017-03-27 Thread em...@n0code.net 
Wow!  Ok - awesome!  Thanks!


> On Mar 27, 2017, at 10:45 AM, Clemens Ladisch  wrote:
> 
> [email protected] 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: http://www.sqlite.org/lang_keywords.html
> 
> CREATE TABLE "TABLE"("#!@""'☺\", "");  -- keyword, special characters, empty 
> name
> 
> 
> Regards,
> Clemens
> ___
> sqlite-users mailing list
> [email protected]
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

___
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

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

2017-03-27 Thread em...@n0code.net 
:)  Roger that.

> On Mar 27, 2017, at 10:58 AM, Hick Gunter  wrote:
> 
>> -Ursprüngliche Nachricht-----
>> [email protected] 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 Quote: 1. Corinthians Chapter 6 Verse 12:
> KJV "All things are lawful unto me, but all things are not expedient"
> NIV "I have the right to do anything,” you say—but not everything is 
> beneficial."
> 
> 
> ___
> Gunter Hick
> Software Engineer
> Scientific Games International GmbH
> FN 157284 a, HG Wien
> Klitschgasse 2-4, A-1130 Vienna, Austria
> Tel: +43 1 80100 0
> E-Mail: [email protected]
> 
> This communication (including any attachments) is intended for the use of the 
> intended recipient(s) only and may contain information that is confidential, 
> privileged or legally protected. Any unauthorized use or dissemination of 
> this communication is strictly prohibited. If you have received this 
> communication in error, please immediately notify the sender by return e-mail 
> message and delete all copies of the original communication. Thank you for 
> your cooperation.
> 
> 
> ___
> sqlite-users mailing list
> [email protected]
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

___
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users