What are the maximum number of columns and rows in a table?

The maximum number of columns in a table is 1,024 and the maximum number of rows is 1,048,576 in Microsoft Excel. However, the maximum number of columns and rows in a database table can vary depending on the database management system being used. Some databases have limits on the number of columns and rows that can be stored in a table, while others may have no specific limits. It is important to check the documentation of the specific database management system being used to determine the maximum number of columns and rows allowed in a table.

Max Columns:

- PostgreSQL (12+): 16,384
- MySQL (8.0+): 65,535
- Oracle Database (19c+): 1,048,576
- SQL Server (2019+): 1024 per table or 3072 per clustered index
- DB2 (11.5+): 32,765
- MongoDB (4.4+): 128 (document fields)

Max Rows:

- PostgreSQL (12+): 2^31 - 1 (2,147,483,647)
- MySQL (8.0+): 2^63 - 1 (9,223,372,036,854,775,807)
- Oracle Database (19c+): 2^63 - 1 (9,223,372,036,854,775,807)
- SQL Server (2019+): 1024^8 - 1 (1,407,374,883,553,280)
- DB2 (11.5+): 2^31 - 1 (2,147,483,647)
- MongoDB (4.4+): 16,777,216