Do I need to add primary key in each and every table

Question

I have a big doubt, For each and every table in my database do I need to add primary key?

Answer 1

Hi Shraddha,

You have a doubt to add a primary key in your table or not? Or is it mandatory to add the primary key?

See, do you know why we use the primary key?

• We use primary key to restrict the data repetition so that our memory storage will not be wasted.
• If You need your table to be joinable on something that time we need primary key
• If you want your table to be clustered, you need some kind of a primary key.

But in database we can create a table without adding the primary key, but experts always preferred tables with primary key.for these facilities.

I hope this answer will help you out ,

Thank you,