Find the Primary Key of a Table Type

[Former Member]

Dear All,

I need to find out the Primary Key of a Table Type SAEVAL_T to store the Data in some other DatsBase.

This Table Type consists of Line Type of Structure SAEVAL_STR .

Can some one help me to find the Primary key of this Table Type.

Thanking You All.

[Former Member]

Hi ,

to find the primary of a table type:

Please follow this way:

Once you open your table type, it was associated with the line type . But in the opened screen you can find the key information, where you can see that it is having the Unique ,Non- Unique and not specified.

In case of associate line type sturcute having any primary key information, this key attributes tab may be specified with Uniquie key information.

Hope this can be helpful.

thanks

[Former Member]

Dear Krishna ,

In the Key Tab ,

Key Category Type is Non-Unique and Key Definition Type is Standard Key.

What can I intrepret ?

[Former Member]

hi ,

with a deep understanding of our Data base systems, we have so many key concepts was availiable.

As per my understanding if they set the key as Non-uniquie, which means that your structure don't have unique key component.

and also you can observe that in the same screen you can find the Key components.

Hope if your structure contain any key components , where they can define those field names over there

Thanks

[antony_paul2]

You can interpret that no keys are defined for your TT

[Former Member]

Since it is non-unique and standard key; see below for you to judge...

1) If TT is structured row type -> key is formed from all character-type columns

2) If it has elementary line type - default key is entire line

3) If it is of non-structured row -> key is entire row

4) If TT's line type is again internal table (nested) -> default key would be empty...