Maximum number of columns in a table, which one is correct?

Question

What is the maximum number of columns in an SQLite3 table? I found an answer:

Maximum Number Of Columns The maximum number of columns is 32767 in a table. The default setting for SQLITE_MAX_COLUMN is 2000.

But I see the error of exceeding maximum number of columns when column number is 1000.

So which one is correct?

Answer 1

I think you pretty much answered your question your self.

As per the official documentation here here

Maximum Number Of Columns

The SQLITE_MAX_COLUMN compile-time parameter is used to set an upper bound on:

• The number of columns in a table The number of columns in an index

• The number of columns in a view The number of terms in the SET clause of an UPDATE statement The number of columns in the result set of a SELECT statement The number of terms in a GROUP BY or ORDER BY clause

• The number of values in an INSERT statement

The default setting for SQLITE_MAX_COLUMN is 2000. You can change it at compile time to values as large as 32767.

On the other hand, many experienced database designers will argue that a well-normalized database will never need more than 100 columns in a table.

Other use full answer to this you can find it here: How to change SQLITE_MAX_COLUMN in Python?

And here: How to increase column limit of a table in SQLite?