CODEWITHSUNDEEP
sql-server
sean2078
sean2078

Reputation: 5440

Is there a byte limit on row size for normal or indexed views in SQL Server?

Understanding there is a 8,060 byte limit on row size for tables when columns are defined ( per https://learn.microsoft.com/en-us/sql/sql-server/maximum-capacity-specifications-for-sql-server ), does the same apply to normal or indexed views in SQL Server?

Upvotes: 0

Views: 205

Answers (1)

TheGameiswar
TheGameiswar

Reputation: 28900

Normal Views just encapsulate query ,so talking about row level sizes for views is not valid

with Indexed views ,data is persisted to disk as seperate copy,view changes into indexed view ,only when you create a clustered index on the view.

However you can't choose wide key with more than 900 in versions earlier than 2016 sp1.So talking about row limit size for indexed view is also not valid

Upvotes: 1

Related Questions