Creating table failed because of the minimum row size

_{Wednesday, January 29, 2014 7:43 AM}

I'm trying to create table where are 40 columns with char(255).
There is no PK or FK. IT is very simple table, but obviously because of size create script fails.

When I remove half of columns and create, it is ok, but I need all columns.

Why? Any work around?

Msg 1701, Level 16, State 1, Line 2
Creating or altering table 'TableName' failed because the minimum row size would be 12522, including 13 bytes of internal overhead.
This exceeds the maximum allowable table row size of 8060 bytes.

Kenny_I

_{Wednesday, January 29, 2014 8:37 AM ✅Answered | 1 vote}

The error message is self explanatory:

Msg 1701, Level 16, State 1, Line 1
Creating or altering table 'Test_Kenny' failed because the minimum row size would be 11232, including 12 bytes of internal overhead. This exceeds the maximum allowable table row size of 8060 bytes.

Why do you want CHAR datatype which is a fixed datatype? Try with VARCHAR(255) (variable), that would solve your issue.

_{Wednesday, January 29, 2014 9:08 AM | 1 vote}

Use Varchar(255) instead of char(255).

char is of fixed memory allocation where as varchar varies. check http://stackoverflow.com/questions/1885630/whats-the-difference-between-varchar-and-char

and http://technet.microsoft.com/en-us/library/ms176089.aspx

Thanks!

Imrana