topic Re: primary key in Application Development and Automation Discussions

primary key

Former Member — Mon, 05 Jun 2006 07:55:21 GMT

hi,

in a table how many primary keys are posiible

Former Member — Mon, 05 Jun 2006 07:57:01 GMT

Hi,

i think a table can have atmost 16 primary keys.

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

Regards,

Aswin

Former Member — Mon, 05 Jun 2006 07:57:28 GMT

Hi kiran,

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

regards,

amit m.

Former Member — Mon, 05 Jun 2006 08:05:43 GMT

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

Former Member — Mon, 05 Jun 2006 08:06:14 GMT

Hii Kiran,

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

Former Member — Mon, 05 Jun 2006 08:08:11 GMT

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>