How many columns can we create in a table in SQLite?

Question

I am creating a SQLite database for my iPhone projects. I have a table called products in my database.

I want to have 35 columns in the product table. I can only create 26 columns. I am adding more so that it is not added to the table. I access the database through the SQLite manager from Firefox. Is there a restriction for columns. How can I solve this problem?

Answer 1

This is most likely a limitation of the Firefox plugin or is related to setting up a naming convention. From the SQLite documentation:

The default value for SQLITE_MAX_COLUMN is 2000. You can change it at compile time to 32767. On the other hand, many experienced database developers will argue that a well-normalized database will never need more than 100 columns in a table.

Solution: use sqlite3 command line interface.