Views and key fields

[Former Member]

I've creted a view and it has marked every field as the key. How do I uncheck the ones I don't want as the key?

[Former Member]

Hi,

<b>View never has key fie</b>lds. The tables of the view has key fields.

What do you mean by key fields in view? Please clarify.

Regards,

RS

[Former Member]

when you go into SE11 and look at the talbe every fiekd is checked in the key column

[Former Member]

Hi Mick,

You must be looking at one of the tables(joined in the view) in SE11. If you want to remove fields as keys in a table, you'll be able to do it in SE11.

But if you want to keep the table as it is and create a view, then all the key fields of the tables have to be included in the view.

regards,

Rohit

[Former Member]

I am looking at the view I created and every field is marked as a key. Is this the way it shuold look? I was expectiong to see only the keys from the tables marked as key fields in the view

[Former Member]

Yes, only the fields which are keys in their respective tables will be marked as key in the view also.

Have you included all keys from the tables?

regards,

Rohit

[Former Member]

I have included all keys form the tables but what i am seein is that in the view every field is marked as key. How do I rmeove the ones that should not be checked. I don't know how that happened but it should not have all marked

[Former Member]

If you do not include all key fields in all tables in your view, the system will automatially make every data field also as key field.

Also, the key fields in the table will also be marked as key in the view but other fields will not be marked.

[Former Member]

i FOUND OUT MY PROBLEM. THE KEYS FIELDS MUST ALL BE AT THE TOP OTHER WISE IT WILL MARK ALL. I MOVED THEM TO THE TOP AND IT WORKED.

THANKS

[Former Member]

What type view are you creating?

[Former Member]

I am creating a database view. maybe all fields should have a check by them in the key column but that seems odd. the fields are not all keys from the tables though