Hello everyone,
I'm trying to import an excel file of 1139 columns to create a new entity table;
the table actually gets created in service studio but, when I try to publish, the following error is displayed:
"Generic SQL Error. CREATE TABLE failed because column 'COLUMN_NAME' in table 'TABLE_NAME' exceeds the maximum of 1024 columns. "
It seems that to extend the maximum number of columns I need to use Sql sparse columns. That said, my question is:have you ever experienced this issue before, and how did you manage to solve it? Thanks in advance,
Hi Gianmaria,
SQL Server restricts the number of columns in a table to 1024. It is not a restriction imposed by OutSystems.You can check that below.
https://learn.microsoft.com/en-us/answers/questions/1479583/how-to-create-a-table-with-more-than-1024-columns
In this article also they are not suggesting creating a table with so many columns. You should divide it in 2 tables.
Thanks,
Neha
Do you strictly need this number of columns?I haven't experienced such an issue, but in case it's really necessary my first solution would be to divide this into two entities with one-to-one relationship.
As before guys answers, you have to refactor your table, or delete unused columns.