[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Maximum number of tables that a  view can hold?

Posted on 2007-10-20
2
Medium Priority
?
485 Views
Last Modified: 2008-02-12
I am trying to create a view. I will be using a lot of individual tables to create that view. I need to know what is the maximum number of tables that a  view can hold?

Can someone have the answere please?.

Thanks,

Zee
0
Comment
Question by:zeeshanbutt
2 Comments
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 2000 total points
ID: 20115744
please read this document:
http://msdn2.microsoft.com/en-us/library/ms143432.aspx

see: Tables per SELECT statement = 256
0
 

Author Comment

by:zeeshanbutt
ID: 20877916
Thanks for the article
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Suggested Courses

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question