Help Center/ GaussDB/ Centralized_8.x/ FAQ/ What is the maximum number of columns in a single GaussDB table?
Updated on 2024-06-03 GMT+08:00

What is the maximum number of columns in a single GaussDB table?

Answer: 1600. The value varies according to the column type. The column type is not verified during table creation but is verified during data storage. For example, for a column of the bigint type, each column stores 8-byte data. If there are 1600 columns, 12800 bytes need to be stored, which exceeds 8 KB on a page, and an error is reported during insertion.