What are valid table names in SQLite?

user_378698 0
Viewed 51814

What are the combination of characters for a table name in SQLite to be valid? Are all combinations of alphanumerics (A-Z, a-z and 0-9) constitute a valid name? 

Ex. CREATE TABLE 123abc(...);

What about a combination of alphanumerics with dashes "-" and periods ".", is that valid as well?

Ex. CREATE TABLE 123abc.txt(...);
Ex. CREATE TABLE 123abc-ABC.txt(...);

Thank you.

sqlite sql
5 Answers

If you use periods in the name you will have issues with your SQL Queries. So I would say avoid those.

user_26212070
Related