2 ms·
There may be other limitations, but MSSQL supports[1]: Columns per nonwide table 1,024 Columns per wide table 30,000 I think a lot of this RDBMs can't do X,
by matwood 8y ago
There may be other limitations, but MSSQL supports[1]:
Columns per nonwide table 1,024
Columns per wide table 30,000
I think a lot of this RDBMs can't do X, came from using a MySQL. It has improved some, but was garbage until recently.
I'm not sure how wide you're taking about, but PG support up to 1600 depending on the datatypes (there is a page size maximum). Oracle supports 1000 IIRC.
[1] https://docs.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server?view=sql-server-2017 https://docs.microsoft.com/en-us/sql/sql-server/maximum-capa...