Table name limit in SQLite Android

Question

Probably I'm giving a little bit trivial question but I'm wondering that is there any limit for table name or field name in SQLite especially in Android. As I good remember there was or still is simillar problem in Oracle Database.

Answer 1

I think that there is no a limit itself for the table name. But it depends on the maximum length of the SQL Statement. By default it is 1000000.

You can check it at http://www.sqlite.org/limits.html

Answer 2

No particular limitation in the sqlite documentation but

• Use name between 1 to 128 byte
• Start with a letter
• Avoid SQL reserved words
• Avoid space