topic Re: Primary key in Application Development and Automation Discussions

Primary key

Former Member — Wed, 07 May 2008 14:19:48 GMT

Which of the folllowing type is taken as the default primary key

TYPE I

TYPE F

TYPE P

TYPE M

TYPE C

Former Member — Wed, 07 May 2008 14:24:46 GMT

Hye,

Primary key is not taken by the Type definitions.

You have expilicity define a primary key for a Data base table. A pk is basically a key which is unique.

Go to SE11, there if you check the key Check box, that column will be the PK for the table.

Hope you understood, reward if helfpful.

Thanks,

Imran.

Former Member — Wed, 07 May 2008 14:26:52 GMT

hi,

Any type defnition field can be taken as a primary key of a table ...

Regards,

Santosh

Former Member — Wed, 07 May 2008 14:31:20 GMT

Purpose of primary key is to identify a unique record.

It can be combination of one or more fields.

So primary key is based on the user's choice which u have to set while creating table.

Based on this one primary index table will be created to improve the access speed.