What are valid table names in SQLite?

by

I haven’t found a reference for it, but table names that are valid without using brackets around them should be any alphanumeric combination that doesn’t start with a digit:

abc123 - valid
123abc - not valid
abc_123 - valid
_123abc - valid
abc-abc - not valid (looks like an expression)
abc.abc - not valid (looks like a database.table notation)

With brackets you should be able to use pretty much anything as a table name:

[This should-be a_valid.table+name!?]

More Related Contents:

  1. Selecting more than one value
  2. Select first row in each GROUP BY group?
  3. Is it possible to insert multiple rows at a time in an SQLite database?
  4. How can I list the tables in a SQLite database file that was opened with ATTACH?
  5. SQLite Reset Primary Key Field
  6. Update table values from another table with the same user name
  7. How to pivot in SQLite or i.e. select in wide format a table stored in long format?
  8. How do I dump the data of some SQLite3 tables?
  9. SQLite – How do you join tables from different databases?
  10. Does SQLite3 not support foreign key constraints?
  11. SQLite – ORDER BY RAND()
  12. Query to get records based on Radius in SQLite?
  13. How do I add a foreign key to an existing SQLite table?
  14. How to use SQL Order By statement to sort results case insensitive?
  15. Select random row(s) in SQLite
  16. Sqlite: CURRENT_TIMESTAMP is in GMT, not the timezone of the machine
  17. sqlite alter table add MULTIPLE columns in a single statement
  18. Is there AUTO INCREMENT in SQLite?
  19. Drop all tables command
  20. Get month from DATETIME in sqlite
  21. How do I import .sql files into SQLite 3?
  22. sqlite equivalent of row_number() over ( partition by …?
  23. How to create timestamp column with default value ‘now’?
  24. String concatenation does not work in SQLite
  25. Android multiple databases open
  26. SQLite3 UNIQUE constraint failed error
  27. Does SQLite3 have prepared statements in Node.js?
  28. SQlite: select into?
  29. IF() statement alternative in SQLite
  30. Copy table structure to new table in sqlite3

Leave a Comment