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: 

Keys in Views ..

former_member425121
Participant
0 Kudos

Hi

Can somebody explain me please how works the keys in a view.

For example, we have some Join for two tables, but we have an existing view just for these both tables so we think tu use the view instead Join in order to improve the performance, but we don't see keys in the view, so we really do not know wich keys are used for acces the view.

Regards

Frank

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Hi Frank,

When you create the View, you will mention the table name and the field name, so if the field is primary key in that table, then that will will become a primary key in the view,

already there will be a check box in the view for primary key, this will be checked automatically if the field is primary key in the corresponding table

Regards

Sudheer

3 REPLIES 3

Former Member
0 Kudos

Try to use the primary keys of one of the tables.

Rob

christian_wohlfahrt
Active Contributor
0 Kudos

Hi Frank!

There are no keys in views - just as you don't specify key fields in a different way as other fields in a select statement.

Regards,

Christian

Former Member
0 Kudos

Hi Frank,

When you create the View, you will mention the table name and the field name, so if the field is primary key in that table, then that will will become a primary key in the view,

already there will be a check box in the view for primary key, this will be checked automatically if the field is primary key in the corresponding table

Regards

Sudheer