Maximum number of tables that can be used to create a view

Question

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?

Answer 1

• 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...

Answer 2

In MySQL, it's 61