Database views tables limit

[BALAJI K R]

Hi Team,

What is the maximum number of tables that we can join in Database view.

Thankyou

[Community Alums · Accepted solution]

Hi @BALAJI K R ,

There is no limit for number of tables, but there'll be impact on performance if the tables are more.

[BALAJI K R]

Thank you

[steveessery]

The information is incorrect, there is a limit of 60 tables, please refer to KB0855858 on NowSupport.

Note that due to the table extension model of the tables in the view there maybe implicit joins added to the query constructed for view, and these are counted in the total number of tables for the purposes of this restriction/limit.  The point about the performance impact is true, but you should also consider the size of the tables being joined and whether any of the view tables has been specified to use a left-join, which can increase the amount of data the view needs to return.