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.

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

 

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

 

Archived

This topic is now archived and is closed to further replies.

×
×
  • 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.