What is the Max number of Columns allowed in SQL Server 2008 View?

Viewed 48300

More of a curious question I can't seem to quickly find an definite answer to.

In SQL Server 2008 is there a max limitation on the number of columns that are allowed in a view? From the MSDN article (below) I see that there is a limit of 4096 Columns per Select statement. Would this then be applied to a View?

Example:

CREATE VIEW [dbo].[TestView]
AS
SELECT     Column1, Column2 FROM dbo.SomeTableName

Would I be limited to 4096 columns in this view?

http://msdn.microsoft.com/en-us/library/ms143432.aspx

4 Answers
Related