Jump to content

[SOLVED] What are primary keys for? Why do I need to specify them?


le007

Recommended Posts

okay. primary key ensures that every record is unique and it also provides an index for searches.

 

i typically include an INTEGER field called ID on all of my tables. I set that field to primary key, auto-incrementing, then it automatically populates as each record is entered. When I get a record, i identify it by it's primary key.

Link to comment
Share on other sites

Primary key is basically used to uniqueally identiy each field of the table and is also used to create the forgion key.

Without PK you can not create the foregion key .(okey)

And

its a basic key in every database programming.

we have more other keys liek

 

Composite primary key

Foregion key

and some others

 

-=--------------------

 

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.