primary key

[Former Member]

hi,

in a table how many primary keys are posiible

[Former Member]

Hi,

i think a table can have atmost 16 primary keys.

For further info on promary keys and foreign keys read this link.

http://cma.zdnet.com/book/abap/ch04/ch04.htm

Regards,

Aswin

[Former Member]

Hi kiran,

1. As many as the number of fields in the table.

regards,

amit m.

[Former Member]

If I'm not wrong, a table can hv single primary key, but primary key may consists of multiple columns..

[Former Member]

Hii Kiran,

<b>A maximum of 16 primary keys are allowed in any RDBMS table.</b>

[Former Member]

Hi,

You can have as many primary key as possible equal to the number if fields in the table.

Regards,

Tanveer.

<b>Please make sure helpful answers.</b>