topic primary key in Application Development and Automation Discussions

primary key

Former Member — Tue, 27 Mar 2007 15:34:00 GMT

how many primary keys we can set in a table?

Re: primary key

RichHeilman — Tue, 27 Mar 2007 15:35:13 GMT

one, you can have many secondary indexes.

Regards,

RIch Heilman

Re: primary key

Former Member — Tue, 27 Mar 2007 15:37:11 GMT

Hi,

I believe the maximum length of the primary key should be 256.

Thanks,

Naren

Re: primary key

Former Member — Tue, 27 Mar 2007 15:37:20 GMT

Hi,

There are two restrictions on the key fields while creating a table.

1) The maximum number of keys in a table is 16.

2) The maximum length of the key fields is 120.

Regards,

Ferry Lianto

Re: primary key

Former Member — Tue, 27 Mar 2007 15:37:48 GMT

as many as u want....it depends on ur requirement...if it is 1 then is a primary key and if it is more it is called a composite primary key....

Re: primary key

Former Member — Tue, 27 Mar 2007 15:40:45 GMT

Hi Sunil,

Primary key is one only it's created when you create a table with KEY Fields.

Hope this answer is with more clarity. Please reward point to useful ans.

Cheers,

Darshan.

Re: primary key

Former Member — Tue, 27 Mar 2007 15:40:46 GMT

Hi Sunil,

A maximum of 16 key fields per table is permitted. The maximum length of the table key is 255.

If the key length is greater than 120, there are restrictions when transporting table entries. The key can only be specified up to a maximum of 120 places in a transport. If the key is larger than 120, table entries must be transported generically.

Regards

Sudheer