Limits and possibilities with Views

[innmedia]

Hi all,

Does anyone know how many tables can be the source of a view? How many total fields?

I have a application that creates many small tables - could be as much as 100. Then, each of these could have up to about 50 fields. There is a key field that relates all the tables.

I need to present the data all together, or at least up to the point that SQL Server can handle. If not all the tables or fields can be included in one view, then so be it. The client knows they are bumping up against limits.

Why use all these little tables? It worked out better performance wise to create many small tables instead of one big table. The data comes via another process. Too long to explain but for the time being the multiple small tables is working best.

Thanks!

 

[ArtieChoke]

If you have SQL2k, then it can handle 256 tables in a select statement. I couldn't tell what the field limit is.

"I think we're all Bozos on this bus!" - Firesign Theatre