primary key

[Former Member]

hi friends,

can u plz explain what is complex primary key?

regards,

siri.

[Former Member]

its more than 1 field as primary key,i believe.

if you make many fields as the primary key set,it would become complex primary key.

Correct me,if i am wrong.

Message was edited by: Srikanth Kidambi

[Former Member]

hi srikanth,

even i dont know this,

i was asked this question in one my interviews.

regards,

siri.

[Former Member]

Hi,

projection view wich is combination of primary keys

of different table .

check below link

http://help.sap.com/saphelp_nw04s/helpdata/en/6d/117c44d14811d2a97400a0c9449261/content.htm

Regards

Amole

[Former Member]

Hi,

Hi,

projection view wich is combination of primary keys

of different table is example of complex primary key.

check below link

http://help.sap.com/saphelp_nw04s/helpdata/en/6d/117c44d14811d2a97400a0c9449261/content.htm

Regards,

Amole

Regards

amole

[Former Member]

hi,

Check this out

http://database.ittoolbox.com/documents/popular-q-and-a/sql-server-simple-vs-complex-primary-keys-21...

Regards,

Santosh

[Former Member]

Hello,

If group o´f fields acts as a key, then it is also called complex keys.

Regs,

Venkat Ramanan N

[Former Member]

Hi sireesha,

1. In any table, there can be many records.

2. To UNIQUELY AND DISTINCTIVELY

identify the FULL RECORD,

we need something unique indicator.

eg. In purchase order table,

the unique thing is purchaser order number.

3. The field (Or combination of fields)

which uniquely identify the records,

IS CALLED AS PRIMARY KEY.

regards,

amit m.

[Former Member]

hi,

A field which is used to identify a particular record in a table can be termed as a primary key. For some types of tables, in which transaction data is stored, it is not possible to identify a particular record using a single field. In these cases we have to use more than 1 field to identify the records, which can be termed as Complex Primary Key. All tables that contains master data, mostly have a singled field as Primary Key. All tables that contains transaction data, mostly have more than one field as Primary key.

Ex: EKKO - (PO Master Table) - - EBELN is the Primary Key

EBELN is used to identify records

EKPO - (PO Item Data)

- - EBELN, EBELP (complex primary key)

Both EBELN,EBELP are used to identify records

Regards,

Vinny