Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
zeeshan13
Constraint Violating Yak Guru
347 Posts |
 Posted - 2007-10-20 : 15:04:10
|
| 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 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-20 : 16:52:00
|
| Up to 256 tables with limit of 1024 columns, they are listed in books online. |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-10-20 : 18:58:22
|
If you gonna hit that limit, something is wrong with somewhere. Better relook into your design
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-10-22 : 03:25:41
|
| Read about Maximum Capacity Specifications in sql server help fileMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Maximum number of tables that a view can hold?