Share via

Row size Warning while creating table

Priya Jha 901 Reputation points
2022-08-26T13:57:41.72+00:00

I am creating a table in Azure SQL DB which has 500+ columns and datatype of multiple columns are nvarchar, decimal, int, etc.

The table is getting created but also receiving this warning:
Cannot create a row of size 8277 which is greater than the allowable maximum row size of 8060. There might be issues while inserting or updating the data.

Any idea why this warning message is getting displayed.

Azure SQL Database
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Nandan Hegde 36,886 Reputation points MVP Volunteer Moderator
    2022-08-26T14:18:20.667+00:00

    Was this answer helpful?

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.