Is there any limit on number of tables to be used to create a view? If there is a limit,then maximum how many no of tables we can use to create a view?
+1
A:
- 256, which the maximum number of tables per select statement SQL 2005
- Limited by resources on SQL 2008
I'd start worrying if you plan to get anywhere near this limit...
gbn
2009-08-21 07:18:16
The reference provided on MSDN doesn't give a maximum it states "Tables per SELECT statement: Limited only by available resources"
Nick Kavadias
2009-08-21 08:02:47
@Nick, my mistake, must have misread or read the SQL 2005 page.
gbn
2009-08-21 08:13:42