Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Maximum tables in a View

Former Member
0 Kudos

in view how many maximum table we can use?plzz tell

Edited by: Alvaro Tejada Galindo on Feb 12, 2008 10:51 AM

4 REPLIES 4

Former Member
0 Kudos

Hi,

A view is an imaginary table or virtual table. Using one or more tables can create a view. Physically, view does not contain any data. The view is filled dynamically during runtime.

View is mainly used to restrict or limit, access to information or data by employees, area, plant and so on. By using view, you can display information specific to a particular user or to their work or the information for which they have the right to access.

Regards,

Bhaskar

Former Member
0 Kudos

A View is nothing But Inner Joins

You can use any no. of tables

then there are many views been made

in sap

so instead of making 1

you should search for a one

thnkx

Former Member
0 Kudos

I'm pretty sure i've seen standard SAP views with well over 10 tables.

Rob

Former Member
0 Kudos

The maximum number of table sources that can be joined in a single query is 256.

For any reference

http://database.ittoolbox.com/groups/technical-functional/sql-server-l/how-many-joins-1851431